Public Kellie, TestName, TestName2, TestRefCount, msg Public TempSheetName, NewProblemName, wSheet Public LastColumn, FirstRow, NewDisplayNameColumn As Integer Public ValueFirstTextbox, ValueSecondTextbox, ValuethirdTextbox, ValueMaxMin, ValueBackorder As Integer Public LabelFirstTextBox, LabelSecondTextBox, LabelThirdTextBox As String Public SheetLocatedinDefault, NewSheetUserName, ProblemName Public DefaultWorkbookName, ToolSheetName, ToolWorkbookName, InputCode Ok I have a module called "codeforall" which contains this in its entirety the bit about the help menu is near the end, which I've commented out and now poses no problem (yesterday when I commented it out, clicking on the Help option in the menu caused it to fail when it tired to find the subroutine i was running Excel 2000 and now I'm using Excel 2003 today, but both versions of VB are roughly the same, v. HelpFile = Application.Path & "\OMToolsHelp.chm"
My second question is that the OpenOMHelp subroutine above is not actually mentioned anywhere in the menu code, so how is it linked to the menu? : I'm struggling to put together a quick VBA knowledge after years of programming in PHP. When I select the option from the menu, instead of loading the help document, i get a compiler error which says "Variable not defined" and it dumps me into this section, highlighting the word App:Īpp.HelpFile = OMToolsAddinPath & ".\OMToolsHelp.chm" HelpFile = Application.Path & '\OMToolsHelp.chm'
0 kommentar(er)
