View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Default value of a List Box on a UserForm

Hi,

Maybe you could use the .Value property once the listbox has been populated.

ListBox1.Value = "FL"

Cheers
Andy

SailFL wrote:
I have a List Box for a couple items on my UserForm. I want to use a default
value so that the user does not have to do anything if the current value in
the list box is correct. One example would be if the choice was enter State
information. If the default was FL, it would automatically get entered and
the user would not have to do anything.

How do you do this for just text boxes?

Thanks


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info