PDA

View Full Version : Solved: Reference a Forms Textbox to a Cell Range



brucel_SA
02-18-2008, 05:07 AM
I Have a Form as a user input in Excel.

in this form i have 2 text boxes
i want to be able to display a value from a range in one of my excel sheets in these text boxes.

is this possible?

Bob Phillips
02-18-2008, 06:06 AM
TextBox1.Text = Worksheets("Sheet1").Range("A1").Text