ComboBox Scrolling
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.
|