listbox
 

assume you have the previous selection in a variable sOldSelect

Dim sOldSelect as String


me.Listbox1.Value = sOldSelect

--
Regards,
Tom Ogilvy

"Cheryl" wrote in message
...
How do I use a listbox to display what was selected last when displaying a
record on a user form based on the contents of the record's cell. The
listbox is populated from a named range on a worksheet but now I need to
know how to display the selected drop down item. This userform can add,
change and delete records. When retrieving information from the rows to make
up a mult-tab form i can retrieve everything but what was originally
selected from the dropdown. is this a select case type of issue.. to put the
highlited selection visible but user still able to change it.