Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA: Automatically activating Private Subs
Hello, I have 21 combo boxes in one worksheet each having its own private sub (Private Sub abc_activate()) for a selection procedure. If I select each sub in the VBA Editor and then click on the run sub/userform button the correct result is shown in the respective combo box. But it does not do it automatically when I click on the workbook or open up the file. How do I automate this clicking orgy? Rgds, Sven -- sven_dau ------------------------------------------------------------------------ sven_dau's Profile: http://www.excelforum.com/member.php...o&userid=35291 View this thread: http://www.excelforum.com/showthread...hreadid=562771 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA: Automatically activating Private Subs
Use the click event of the combobox.
-- Regards, Tom Ogilvy "sven_dau" wrote: Hello, I have 21 combo boxes in one worksheet each having its own private sub (Private Sub abc_activate()) for a selection procedure. If I select each sub in the VBA Editor and then click on the run sub/userform button the correct result is shown in the respective combo box. But it does not do it automatically when I click on the workbook or open up the file. How do I automate this clicking orgy? Rgds, Sven -- sven_dau ------------------------------------------------------------------------ sven_dau's Profile: http://www.excelforum.com/member.php...o&userid=35291 View this thread: http://www.excelforum.com/showthread...hreadid=562771 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA: Automatically activating Private Subs
Tom, If you mean changing from _activate to _click, i.e. from Private Sub abc_activate() to Private Sub abc_click() in the VBA Editor then it does not work. The combo box remains empty. Also, combo box properties does not have an event item. ? Thanks, Sven -- sven_dau ------------------------------------------------------------------------ sven_dau's Profile: http://www.excelforum.com/member.php...o&userid=35291 View this thread: http://www.excelforum.com/showthread...hreadid=562771 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
re : Possible to run private sub macros by writing another private | Excel Programming | |||
Private Sub Running Other Private Sub Inadvertently | Excel Programming | |||
Private subs | Excel Programming | |||
Calling VBA add-in functions/subs from another Excel file. | Excel Programming | |||
calling private subs | Excel Programming |