how do I link Textboxes in a userform to a Cell in a Worksheet?
 

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?

how do I link Textboxes in a userform to a Cell in a Worksheet?
 

Paul,

You need to set the Controlsource property when designing the form.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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?

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?