Thread: Listbox default
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Listbox default

ListBoxYear.Value = strYear

--
Regards,
Tom Ogilvy

wrote in message
...
Is there a way to have one of the values that has been added to a
listbox appear as the 'default' value? I tried the code below but it
does not do it.

Set ListBoxYear.Value = strYear