Help with dropdown boxes and preset selections

[Keving]

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]

bump |

[Gonzo]

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