How to Apply a Value to a Text Box (ActiveX Control)

[nryan]

Hello,

I have several Text Boxes (ActiveX Control) on my worksheet. On a separate worksheet (same workbook) I have a single column of cells that have number values that change. I don't think it's relevant to explain how or why they change, but it's because of a VBA macro where a user selects one option each from a few list boxes and the relevant values are populated into the column. That problem has already been worked out. Now I'm trying to populate the text boxes with all the values in the column.

Note: I've used .ListFillRange to populate List and Combo Boxes, but I don't see that option in the Properties box of the text boxes. I see "Value" and "Text" and "LinkedCell".

Thank you.

 

[antialias401]

If you want one textbox to display one cell value:

Inside the INITIALIZE portion of your user-form place:

TextBox1.Text = Range("A1").Value
TextBox2.Text = Range("A2").Value
And So On

IF all you want to do is display the cell value inside the textbox (and never-ever change that value)...
Then perhaps using Labels will look a little cleaner for you. So instead of using Textboxes, you can use Labels.
Of course, this is just another option (Also goes inside the Initialize portion of your user-form)...

Label1.Caption = Range("A1").Value
Label2.Caption = Range("A2").Value
And So On

Hope this helps