View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
 
Posts: 493
Default User form question

in your userform initialization code:

ListBox1.ListIndex = ListBox1.ListCount - 1

In article ,
"Haas" wrote:

Hi all,

I have created a userform with a list of dates to choose from in a List Box;
the user can choose only one date, but in case they don't, there is always a
default date selected, being the last item on the list. How can I achieve
this?

Thanks much in advance!