Userforms

[Guest]

Hi

I am very new to this and I would like to find out how I can link any object in a userform (Textbox, combobox etc) to a cell in a worksheet so that when the form has been filled in it shows the info in a worksheet...

Can anyone help?

 

[Tom Ogilvy]

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

Hi,

I am very new to this and I would like to find out how I can link any

object in a userform (Textbox, combobox etc) to a cell in a worksheet so
that when the form has been filled in it shows the info in a worksheet....

 

[Guest]

Thanks Tom