Simple question - how to "link" a Text box link to a cell reference.

[nevadanuke]

Starting out, I have a Dialog Box with a Text Box that I am trying to use for user input. (I am new to this so, I am not certain I am using the right control.) If a user updates the value in the text box, I need the value to "link" (via VBA) to a R1C1 cell reference or "cell". I am not sure I said that right, but you probably see where I am going. Any hints?

 

[lambuhere1]

Assuming that the text box is referenced as textbox1, try this

sheets(1).cells(1,1).value = Userform1.textbox1.value

I am taking that the text box is on the form.

This refers the value of the text box to cells A1 . Use this in the text box change event.

I am also new to this, but a try is worth it.

Ram P

 

[xlbo]

By your usage of "Dialog box" are you using excel 95 ?? if so, the coding is slightly different to that which Ram posted, which will work very nicely for 97 and onwards.
If you are using e95, I should be able to help as I can still (vaguely) remember the coding structure
Rgds
Geoff

 

[nevadanuke]

Awesome. Office 2000 is where I am coding. I will give it a shot. Thanks to both of you.

 

[ratman]

Range("Sheet1!A1&quot.value = UserForm1.TextBox1.value