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