Drop Down List

[accessman2]

Hi,

In the userform, it has many events on the combo box.

I want to create Drop Down List on the worksheets,
I know how to create the events on the combo box.
But, how to create the events on the drop down list? Excel only offer Change Event, do they have any other events offer?

 

[shades]

Howdy. Perhaps a little further explanation. There are three ways to accomplish "dropdowns" within Excel itself, not counting VBA. Are you using dropdowns through Validation, Forms, or Control Toolbox? Or using VBA UserForm?
________
CX

 

[accessman2]

I use the combo box from the Form toolbox.

 

[shades]

Okay, can you explain more what you are trying to do (maybe attach a small sample?). It may be that Validation will work for you.
________
Lamborghini concept s history