ComboBox Scrolling
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. |
ComboBox Scrolling
Pete
You'll need to show the code you are using to populate and control the box in question for further advice Cheers Nigel "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. |
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. |
ComboBox Scrolling
The populate code goes like this:
.... cb.Clear cb.AddItem "My heading" For i = 1 to ItemRange.Rows.Count cb.AddItem Format(ItemRange.Cells(i, 1).Value, "dd/mm/yyyy") Next i cb.ListIndex = 0 .... The underlying data is pretty volatile, so I've been calling it from the cb_GotFocus event-handler. (I don't know a good place to call from upon initialization.) Thanks very much for your attention. "Nigel" wrote in message ... Pete You'll need to show the code you are using to populate and control the box in question for further advice Cheers Nigel "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. |
ComboBox Scrolling
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. |
All times are GMT +1. The time now is 09:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com