Reading data from a cell to a text box

  • Thread starter Thread starter Aaron1978
  • Start date Start date
A

Aaron1978

Hi All,

I have a user form with a number of text boxes. How do you read data
from a cell in a workbook to the text box in the user form? The text
box is called txtDiameter and I assumed the code would be quite simple
and tried the following:

txtDiameter = Cells(2, 3).Value

txtDiameter on the user form remins blank. Does any body have any
ideas?

Best Regards,

Aaron
 
Userform.txtDiameter.Caption = Cells(2, 3).Value

should do the trick
/roger
 
Hi Aaron,

You've got the reference to the object (txtDiameter). You just need to set
its 'Value' property, so:

txtDiameter.Value = Cells(2, 3).Value

Best regards

John
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate Cell with Content of Text Box 10
Format Text Boxes within A User Form 3
User form Text Box & Combo Box. 5
Hello happy new year to all, Text box input for year of purchase 0
Linking Cell Data to Text Boxes on a Form 1
How to activate a User Form 1
Text boxes in forms 1
Reading Data from a User Form. 2

Back
Top