PDA

View Full Version : Entering Selected Cell Values in Multiple Textboxes



kishlaya
06-21-2010, 08:28 AM
Dear Friends

I have a userform with a number of textboxes. The user needs to click inside each text box and then goes on to click a cell in a sheet, which will put the value of the cell in the textbox. The user then moves into the next textbox and follows the same process.

My question is how can i put the the value of the cell to the textbox, since the user is free to choose any cell.
I am trying to write the code in Worksheet_Change event but to no avail :dunno.

Hoping for some positive and helpful replies .

Regards,
Kishlaya

Bob Phillips
06-21-2010, 10:12 AM
Why not add a small button next to each textbox that the user clicks and then they get an InputBox to select the cell, when selected, dump the textbox onto that cell.