Now, you can call your macro from another module (Module2 in our example) just like you would call a Public Sub. PrivateSubPrivateCallDemo4()'Module2CallModule1.HelloWorld2EndSub Note: TheCallkeyword is optional when calling a module ...
Now I want to run it from another macro - should be simple enough to write: Call Re_Set - there is 1 optional argument that I don't need, but it just says Sub or Function not defined. How do I get it to recognise a Personal routine? [Sorry if...
How do I call an Excel VBA PERSONAL procedure from a subroutine of another project? Phil157 Try Application.Run"PERSONAL.XLSB!Re_Set" Worked like a charm - thank you very much. While I've got you here... For the last few years, since using Office 365, I've...
check if files exist in directory and subdirectories Check if folder has subfolders (fastest) Check if form is closed Check if input string matches a specific format Check if Last Character of a String Is A Number check if one of the Checkboxs in a groupbox is checked Check if right-mouse...
Creating subitems using UL LI in asp.net webforms master page Creating Word from XML XSLT Credit card payment using Merchant Account in asp.net c# application Cron Job in C# asp.net cross site scripting attacks and textboxes cryptographic exception in user code - The parameter is incorrect. ...
Use the following procedure in theThisDocumentclass module. Sub A(shpObj As Visio.Shape) MsgBox "Click OK." End Sub Sub B(shpObj As Visio.Shape, strA As String) MsgBox strA End Sub Sub C(shpObj As Visio.Shape, strA As String, strB As String) MsgBox strA & strB End Sub ...
Use the following procedure in the ThisDocument class module. Sub A(shpObj As Visio.Shape) MsgBox "Click OK." End Sub Sub B(shpObj As Visio.Shape, strA As String) MsgBox strA End Sub Sub C(shpObj As Visio.Shape, strA As String, strB As String) MsgBox strA & strB End Sub Use an...
Use the following procedure in the ThisDocument class module. Sub A(shpObj As Visio.Shape) MsgBox "Click OK." End Sub Sub B(shpObj As Visio.Shape, strA As String) MsgBox strA End Sub Sub C(shpObj As Visio.Shape, strA As String, strB As String) MsgBox strA & strB End Sub Use an...
CantAccessRootwebResourceBySubwebUrl field CantAddDuplicatedPrefix field CantChangeAllAdminRole field CantChangeDomainAccountPassword field CantChangeOwner field CantCreatePageInherits field CantCreateSPFileWithoutSPFolder field CantCreateSPFileWithTemplateWithoutList field CantCustomizeFormsForUserInformationList field...
My background: I have experience in AML, Avenue, some VBA, some VB6, and now I am having to figure out VB.net 2010 and the new Add-in module. I don't get much time to write code, in fact, it has been almost two years since I have attempted coding and...