Text boxes and control source
 

Still a beginner in VBA, and have the following problem. I have
spreadsheet that has various sheets etc which perform variou
calculations. I have designed a user form for the user to enter th
data required in various text boxes on the user form (therefore savin
the user navigating the sheets, and ensuring that all required boxe
have data in them). I then want the data in the text box to transfe
to one of the sheets in excel. I have noticed that if i enter the cel
reference in the ControlSource property of the text box e.g. = a2, i
links both ways with that cell in the text box and the cell in th
first visible sheet. However, how do i get it to place the text in sa
cell a2 of say sheet 5?

Any help would be appreciated as i keep hitting a brick wall!!

Cheers

Sa

--
Welsh
-----------------------------------------------------------------------
Welshy's Profile: http://www.excelforum.com/member.php...fo&userid=1601
View this thread: http://www.excelforum.com/showthread.php?threadid=31481

Text boxes and control source
 

sheet5!A2

in control source

--
Regards,
Tom Ogilvy

"Welshy" wrote in message
...

Still a beginner in VBA, and have the following problem. I have a
spreadsheet that has various sheets etc which perform various
calculations. I have designed a user form for the user to enter the
data required in various text boxes on the user form (therefore saving
the user navigating the sheets, and ensuring that all required boxes
have data in them). I then want the data in the text box to transfer
to one of the sheets in excel. I have noticed that if i enter the cell
reference in the ControlSource property of the text box e.g. = a2, it
links both ways with that cell in the text box and the cell in the
first visible sheet. However, how do i get it to place the text in say
cell a2 of say sheet 5?

Any help would be appreciated as i keep hitting a brick wall!!

Cheers

Sam


--
Welshy
------------------------------------------------------------------------
Welshy's Profile:
http://www.excelforum.com/member.php...o&userid=16019
View this thread: http://www.excelforum.com/showthread...hreadid=314818