View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?