| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Box Selections
Hi, I'm programming VBA in Excel 2k3. On my custom dialog box, I made a list
box with three choices in one column. It is sized so that only one choice is visible at a time. Vertical scroll buttons (up and down) are present on the right side to change between the visible options. If I press the 'up' or 'down' keys on the keyboard, the visible option is changed AND selected. But if I use the mouse to click the up or down scroll buttons, the newly shown option is not selected. Can I have the options automatically be selected when I click those scroll buttons? Thanks, Steven |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List Box Selections
No.
-- Regards, Tom Ogilvy "BeefmanSteve" wrote in message ... Hi, I'm programming VBA in Excel 2k3. On my custom dialog box, I made a list box with three choices in one column. It is sized so that only one choice is visible at a time. Vertical scroll buttons (up and down) are present on the right side to change between the visible options. If I press the 'up' or 'down' keys on the keyboard, the visible option is changed AND selected. But if I use the mouse to click the up or down scroll buttons, the newly shown option is not selected. Can I have the options automatically be selected when I click those scroll buttons? Thanks, Steven |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List Box Selections
Steven
The TopIndex property will return the position (zero based) of which item is showing. While the item won't be selected, you can still retrieve it using TopIndex. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com BeefmanSteve wrote: Hi, I'm programming VBA in Excel 2k3. On my custom dialog box, I made a list box with three choices in one column. It is sized so that only one choice is visible at a time. Vertical scroll buttons (up and down) are present on the right side to change between the visible options. If I press the 'up' or 'down' keys on the keyboard, the visible option is changed AND selected. But if I use the mouse to click the up or down scroll buttons, the newly shown option is not selected. Can I have the options automatically be selected when I click those scroll buttons? Thanks, Steven |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow for multiple selections from a list | Excel Worksheet Functions | |||
| List all selections from drop down | Charts and Charting in Excel | |||
| Print selections from a list | Excel Discussion (Misc queries) | |||
| List Box Selections | Excel Worksheet Functions | |||
| List box with multiple selections | Excel Programming | |||
Linear Mode
