Cheryl.

Where is the data that shows in the listbox?

On the second point it depends. It could be on the click event, but you
might want to add a commandbutton and use that control's click event. ,It is
a design decision.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Cheryl" wrote in message
...
Good day...

I know this is probably simple.. but I am not sure how to do this..

I need to take data from a cell and show it as current selection in the
listbox on a user form. The data for the list box is originally populated
from a two column range. My form shows add, change and delete records. As
it
loads a record, it should show what is the current selection for that
record
in the list box. I am not sure where to code this. Then, the user has the
option to change the displayed information and write it back to the
worksheet. I don't know how to code this.. Should it be in listbox change
event??? and load record event... for retrieving it from the worksheet
initially..

Help... would be greatly appreciated.. Thank you.