Showing contents of specific cell in form's textbox

M

Mike

I am trying to set up a form with TextBox_Change() Private Sub in it and would like the form to show what is in a specific cell prior to changing it. This way when the form is open, only the things that need to be changed need changed. How can this be accomplished? I know I can add something in the Text Property, but I would like it to read the excel file and show what is in the cell as the textbox text. Hope this makes sense.

Thanks,
Mike
 
D

Dave Peterson

Maybe you could plop the value in when your form is loaded:

Under the UserForm code module:

Option Explicit
Private Sub UserForm_Initialize()
Me.TextBox1.Value = ThisWorkbook.Worksheets("sheet1").Range("a1").Text
End Sub
 
M

Mike

Dave,

What you gave me is something I can work on. It seems to be pointing me
in the right direction, but I wasn't able to get anything to show in the
forms textbox. I may need to play with it some, but I do believe you have
me pointed in the right direction.

Thanks!
 
M

Mike

GREAT!!!!!! That did the trick, I didn't realize my Sheet1 was named
differently. I really, really appreciate your help. Now I can get finish
setting up the form!!

Mike
 
Top