Thanks Dave

I have not used listboxes before and I have struggled to find onlin
examples. Perhaps what I want cannot be done!

Now I am getting somewhere! I can edit because I know the cel
references but my user can only see a listbox on a userform - they hav
no idea of the location of the text. Is it possible to select the cel
via the active line of the listbox?
I would like it to work as follows
Listbox1 covers D1:D100 - each cell contains text
The user scrolls through the listbox and selects the text to edit
they click command button1 to put the cell value into textbox1
textbox1 is edited as required
they click commandbutton2 to update the cell

any ideas

Kenn

--
N E Bod
-----------------------------------------------------------------------
N E Body's Profile: http://www.excelforum.com/member.php...fo&userid=1126
View this thread: http://www.excelforum.com/showthread.php?threadid=27006