Excel VBA: Automatically activating Private Subs

[sven_dau]

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

[Tom Ogilvy]

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
>
>

[Tom Ogilvy]

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
>
>

[Tom Ogilvy]

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
>
>

[sven_dau]

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