Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

bringing values in cells to textbox in form

  Asked By: Binge    Date: Feb 15    Category: MS Office    Views: 909
  

I have a problem:

I like to bring value in a cell in excel worksheet to a textbox in a
userform.

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Mildred Bailey     Answered On: Feb 15

Private Sub UserForm_Initialize()
Me.TextBox2.Value = Sheets("Sheet1").Range("C3")
End Sub

 
Answer #2    Answered By: Lee Butler     Answered On: Feb 15

Right click on the text box and select properties. In the property
display set the attribute CONTROLSOURCE to the cell  in the worksheet
you are interested in. You may wish to name this cell and then refer
to the name in CONTROLSOURCE

 
Didn't find what you were looking for? Find more on bringing values in cells to textbox in form Or get search suggestion and latest updates.




Tagged: