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.

You can use MATCH to find the index, something like

Application.MATCH(Listbox1.Value,Range("A1:A10"),0 )

then set the listindex accordingly

Listbox1.Listindex = ... that value ...

--

HTH

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

"Cheryl" wrote in message
...
The listbox data is in 2 columns on a spreadsheet and is a named range.
The
data that will be displayed when a record/row is retrieved/loaded is on a
worksheet called 'Job Number List' in a cell called ID.


"Bob Phillips" wrote:

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.