Help with dropdown boxes and preset selections
 

My goal is to make a macro that will bring up window A (dropdown list
selection) and has, in the window, preset selections on the dropdown
list.

So for example, a dropdown list of 5 selections numbered 1 to 5 (1
being the one at the top, 5 being the one at the bottom), could I have
the macro be created to have lets say when the window opens, option 3
in the dropdown list is selected by default?

This all takes place in the Custom AutoFilter and im trying to have "is
greater than" selection on the top box and "is less than" selection on
the bottom box.

Thanks


--
Keving
------------------------------------------------------------------------
Keving's Profile: http://www.excelforum.com/member.php...o&userid=35826
View this thread: http://www.excelforum.com/showthread...hreadid=559381

Help with dropdown boxes and preset selections
 

bump |


--
Keving
------------------------------------------------------------------------
Keving's Profile: http://www.excelforum.com/member.php...o&userid=35826
View this thread: http://www.excelforum.com/showthread...hreadid=559381

Help with dropdown boxes and preset selections
 

I'm assuming you use a userform.

Syntax: object.Selected( index ) [= Boolean]

For example:
lstMyCustomList.Selected(2) = True
- using index 2 selects the third item

This what you wanted?

Keving schreef:

bump |


--
Keving
------------------------------------------------------------------------
Keving's Profile: http://www.excelforum.com/member.php...o&userid=35826
View this thread: http://www.excelforum.com/showthread...hreadid=559381