VBA code referring to UserForm textbox text?

[PB7]

All, I've somehow managed to fail to assimilate what maybe a simple thing:

A UserForm I have has some textbox fields, to receive text of a person's name, process status, etc.

How do you permanently save a text box value in the UserForm, and then retrieve whatever the current value of the text box is, in code like this:?

ActiveCell(Offset 0,3).Value = TextBox1.Text

Or do you also input the UserForm name as well:?

ActiveCell(Offset 0,3).Value = SampleUserFormName.TextBox1.Text

Totally stumped. Thank you in advance for any help here.

 

[Norie]

What do you mean permanently save?

If you just mean put the value from the textbox on a worksheet either of those should work, depending on where the code is though.

The first and second one will work in the userform module.

In other modules you would need to use the second one.

 

[PB7]

Norie, I think I get it...I need a ControlSource for a textbox, right? Which holds the text input, as entered through the UserForm. That's what I think I'm missing. Let me try this. Many thanks for the quick reply.

 

[Norie]

Well you can use the ControlSource but you shouldn't need to.

In fact using ControlSource is sometimes not that good an idea.

It's a 2-way thing, whatever you enter in the textbox will go to the worksheet and whatever's entered on the worksheet will goto the textbox.

So if you needed to clear the userform for whatever you are doing, eg data entry, then you could end up clearing what's just been put on the worksheet.

Obviously you can get round that by moving the data on the worksheet to another location.

If you don't use ControlSource all you need is code like that you've posted to put the data from the userform onto the worksheet.