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