how do I link Textboxes in a userform to a Cell in a Worksheet?
look at the control source property of the control in the properties window.
sheet1!A1
in the control soucre property would case a value in the control to appear
in cell A1 of Sheet1
--
Regards,
Tom Ogilvy
Paul Clark wrote in message
news:9B814D98-7F88
Paul Clark wrote in message
...
I am new to excel and I am trying to do a project for work so that users
can fill in various userforms that will then update to a Worksheet. Can
anyone tell me how I link an oject in a userform(Textbox, Combobox etc) to a
cell in a worksheet?
|