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

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

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