Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Excel- smooth scrolling (instead of 'snap' scrolling) | Setting up and Configuration of Excel | |||
Vertical scrolling...jumps rather than smooth scrolling | Excel Discussion (Misc queries) | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta | Excel Discussion (Misc queries) | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 | Excel Discussion (Misc queries) |