Entering Selected Cell Values in Multiple Textboxes

[kishlaya]

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 .

Hoping for some positive and helpful replies .

Regards,
Kishlaya

[Bob Phillips]

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.