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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 said:
I am new to excel and I am trying to do a project for work so that users
Click to expand...
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?
 
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 said:
I am new to excel and I am trying to do a project for work so that users
Click to expand...
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?
 
Back
Top