Help with basic userform

[Offeror]

Hi guys,

gotta fill userform textbox with a value that is in a cell in active worksheet. I've tried controlsource and it works ok but not perfect because I want the textbox to be shown empty when the form opens.

I've tried

Activesheet.Range("D43")=TextBox1.Value

thinking that it would pick the D43 value but didn't happen, but then I got rid of the activesheet coz I figured not stating it means activesheet so

Range("D43")=TextBox1.Value

But this doesn't work too.

Help needed.

Regards.

 

[VoG]

Shouldn't it be?

TextBox1.Value = Range("D43").Value

 

[Offeror]

Shouldn't it be?

TextBox1.Value = Range("D43").Value

This does the opposite of what I want i.e. the user enters the text in the textbox, and that goes to range("D43").value

I want the range("D43") value to come into the textbox as soon as it is calculated (by a lookup function). But that doesn't work.

My vba is really preliminary so I might be wrong. I'm just telling from what I've experienced after giving it a shot.

Thanks.

 

[VoG]

Your original code should work then. In what way does it not? It might be an idea to post your complete relevant code using code tags

[code]
your code here
[/code]

 

[Offeror]

Here's the code I've entered on double clicking the relevant textbox:

Private Sub TextAdv_Change()

ActiveSheet.Range("D5").Value = TextAdv.Value

End Sub

Where Textadv is the name of the textbox. I actually also made a search from some site and I tried their suggestion too which was:

Private Sub TextAdv_Change()

ActiveSheet.Range("D5").Value = TextAdv.Text

End Sub

Thanks for your response, and I hope I'm not doing a stupid mistake.

BTW the code I found was opposite of this, which is used to get textbox value to cell. But I tried reversing the code, hoping it might work.

Regards.

 

[VoG]

That code works for me. Where did you put the code? It has to go in the userform's code module.

 

[Offeror]

You're right, I also tried it again with a fresh workbook and a very basic table so that the problem could be detected.

But when I tried it afresh, it worked perfectly. Maybe something I was doing differently before. I'm not sure. Anyways thanx a lot for your time.

I'm still working on the userform, and I'll try to figure out things best as I can, but if something doesn't work for too long I might call on you again.

Regards.