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
--
SailFL

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