Text boxes and control source

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate Cell with Content of Text Box 10
User form Text Box & Combo Box. 5
Form Textbox Mulitline question 3
User Form Problem 2
Macro to retrieve values corresponding to the value selected in Dropdown box 4
Eliminate blank row at top of Text Box entries 3
combo box 2
Using a single cmdButton to perform different tasks 5

Top