Vasant -

I chose the Control Toolbox for 3 reasons:
- (Most important) At runtime, I sometimes need to make the control
invisible. Is there a better way to do this? With Forms Combobox?
- A book I read recommended that we avoid using Forms controls.
- As an option, it wold be nice (not critical) to have access to the
"Shift" parameter of the MouseDown event.

If there are other ways of achieving these features?

Thanks for your attention.

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ...
Control Toolbox ComboBoxes when used on worksheets are very buggy. Can you
work with a ComboBox from the Forms Toolbar (less flexible but more stable)?

--

Vasant

"Pete" wrote in message
om...
I am having trouble with a combobox on an Excel worksheet. Since I
want to display dates (in date format), I populate the list from VBA.
However, the first time the user clicks on the combobox after it is
populated, the entire list is crammed into the top row of the
dropdown, with a spinner or a 1-row scrollbar allowing choices. The
rest of the dropdown is blank. After the first click on the combobox,
it behaves nicely.

Has anyone seen anything like this? Any ideas?

Thanks.