Hi

I have a range of cells (D2:D100) Which the user needs to edit - Th
user can only access these cells via a userform. The userfor
currently has a listbox to allow the user to see the contents of th
cells.

How can I set it up to allow the user to select a cell - edit the tex
- update the cell with the edited text?

I tried VBA help and tried AddItem etc but could not get it to edit th
cell.

Any suggestions and advice would be much appreciated!

Kenny
Win 2000 - Excel 9

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