Showing contents of specific cell in form's textbox

  • Thread starter Thread starter Mike
  • Start date Start date
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
 
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
 
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!
 
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
 
Back
Top