Userform to enter data

**phalcon45** · 11-10-2012, 10:23 AM

Im learning my way around userforms and this is probably a rookie question but I'm trying to figure out how to have a text box display the contents of a cell but if I enter text into the box have it replace the contents of the cell it read from.
For example, if my A1 contained "Good bye" my form would display that but if I type in "Have a nice day" in the text box (Textbox1) it replaces whats in A1 with that text string.
Im sure its simple (thats part of what forms are for) but I dont understand how to make it work.

Thanks in advance!

**Sadath31** · 11-10-2012, 10:42 AM

Hi
to show A1 contents in text box, you can put in userform activate event like:

Please Login or Register  to view this content.

and A1 to replace the text box content

Please Login or Register  to view this content.

**davesexcel** · 11-10-2012, 10:47 AM

Try this out

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

**BlindB** · 11-17-2012, 08:19 AM

Hi,

I'm only new here but If you want to use the UserForm for input the I would suggest linking the Textbox on the UserForm with the Cell you require.

Doing this is quite simple. If you highlight the TextBox and then look at the TextBox properties in the VBA Editor where you made the userForm and scroll down the list you will find one called "ControlSource".

All you need to do is now direct this to the Cell you want and type in as an example =Sheet1!A1

You have now linked the two together and from now on what ever you type in the text box will change on the worksheet and visa versa.

Hope this is what you were after.

Cheers