Adding multiple combo boxes to worksheet

[denko]

Is there way to add through the vba multiple combo boxes ( as many as there are rows, more than 500) to a worksheet?

 

[SkipVought]

Hi, denko,

Why would you want to add that many?

ONE IS ENOUGH!

Here's the way to do it.

1. Add ONE ComboBox to your sheet.

2. Whenever the user selects an appropriate cell, using the Worksheet_SelectionChange event, make the ComboBox visible and assign the appropriate List to it.

3. Code the ComboBox_Click Event to be context sensative.

4. Either when the user seletes from the ComboBox OR if the user selects another cell, assign False to the Visible property.

This way you only have two procedures to code.

Hope this helps Skip,
metzgsk@voughtaircraft.com

 

[denko]

You're right.
Thanks