View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sven_dau[_5_] sven_dau[_5_] is offline
external usenet poster
 
Posts: 1
Default 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