Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I added a macro to a form I created so that users would tab through the cells
in numerical order. After running the macro, I tested the form to ensure that it was still working correctly. There are checkmark boxes in the worksheet that are programmed with visual basic to transfer the data from each row that users select to another sheet within the same workbook. Since adding the macro, when I click a checkmark box, I get the error message: "Compile error: Sub or Function not defined." I click OK and then it takes me to my VB programming: Private Sub CheckBox5_Change() (This is highlighted in yellow) Call startstop (This is selected with blue) If I leave VB open, the form works the way it was intended to. If I close VB, I get a message that says "This will stop the debugger" and then the worksheet doesn't work correctly. The macro I added is: Sub AutoOpen() Range("D1,D2,D3,D4,D5,F1,F2,F3,F4,F5,N1").Select Range("D1").Activate End Sub Sub AutoOpen() is highlighted in yellow, since trying to use the checkmark boxes. Is there another step I need to do, or does this macro need to be inserted into my VB code somewhere. Susan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trouble adding timesheet formulas | Excel Worksheet Functions | |||
trouble adding addins | Excel Discussion (Misc queries) | |||
trouble adding addins | Excel Discussion (Misc queries) | |||
trouble adding to list. | Excel Programming | |||
I am having trouble adding a row in Excel. What am i doing wrong? | Excel Worksheet Functions |