G
Guest
Guest
I've got a ComboBox ActiveX dropdown control on a worksheet that needs to be initialized with a dropdown list.
What's the best way to do this?
I've tried ComboBox1_GotFocus and ComboBox1_Click without any luck. I've been able to get the list to appear on the second click, but not on the first.
Also tried Worksheet_Activate, but it doesn't seem to work either.
Any suggestions? I know this must be easy.
What's the best way to do this?
I've tried ComboBox1_GotFocus and ComboBox1_Click without any luck. I've been able to get the list to appear on the second click, but not on the first.
Also tried Worksheet_Activate, but it doesn't seem to work either.
Any suggestions? I know this must be easy.