Reading data from a cell to a text box

[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

[roger nordman]

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

should do the trick
/roger

[John]

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


"Aaron1978" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
>
> --
> Aaron1978
> ------------------------------------------------------------------------
> Aaron1978's Profile:
> http://www.excelforum.com/member.php...o&userid=31201
> View this thread: http://www.excelforum.com/showthread...hreadid=519726
>

[Aaron1978]

Thanks for your help guys. Worked fine.