update a textbox user form when user form is open

[Lauren279]

hi

i would like a textbox userform (called Ref) to update with a number with in a spreadsheet

the number is in column A and it needs to show in the textbox if in column B is blank

i have tired using

Private Sub Ref_Enter()
Ref.Text = Range("b" & Rows.Count).End(xlUp).Offset(0, -1).Value
End Sub

but nothing happens

Please Help!

 

[AlphaFrog]

The description is thin on detail.

Based on the thread Title, if you want to populate the textbox when the userform initializes...

[color=darkblue]Private[/color] [color=darkblue]Sub[/color] [COLOR=#ff0000]UserForm_Initialize()[/COLOR]
    Ref.Text = Range("b" & Rows.Count).End(xlUp).Offset(0, -1).Value
End [color=darkblue]Sub[/color]

 

[Lauren279]

thank you, i also had it has not the userform code

sorry the description was thin, i couldn't figure out how to describe the problem, but it is all fixed now and working (it was the initialize part i was missing)

thanks heaps<o></o>

 

[AlphaFrog]

You're welcome. Glad it worked out.