View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keving Keving is offline
external usenet poster
 
Posts: 1
Default 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