Using change event for combo box created at runtime (VB6)

[camphor]

ComboBox_Change Event in Controls.add

Hi,

I am a newbie to this forum and VB. I have gained some experience in creating combo boxes. I am facing a problem with combo box created at runtime. I am not able to figure out the firing of combo_Change event in this case, since the variable name (or should i say object?) of the new combo box is created at runtime.

In UserForm code, I have added a new combo box at runtime

Please Login or Register  to view this content.

On UserForm
The combo is displayed.
How can I set the Combo_Change event procedure in UserForm coding?

Thanks in anticipation.

PS: Related unsolved thread: http://www.excelforum.com/excel-prog...trols-add.html

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[camphor]

Sorry for the inconvenience. Edited the code portion.

[Kyle123]

Have a look here, it's a bit more complex than you need, but it is exactly the same principle

[camphor]

Hello, Thanks for the reply.

Unfortunately I could not understand much from the link. If possible could you simplify the implementation for me, considering i am new to vb and excel. Thanks in advance

[buran]

Hi camphor,
Have a look at the sample workbook.
Note that i have changed your code as it will put all combo-boxes (i assume there will be more than one on the form) one over another.
Buran

[camphor]

Hello, thanks for the prompt reply. I would further build on this code and hopefully I would proceed in my implementation.

[buran]

Great! You may find useful to look at this http://www.cpearson.com/Excel/Classes.aspx as a basic reference for use of own class