Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help w/ userform with 12 textboxes with data going into colum | Excel Discussion (Misc queries) | |||
UserForm TextBoxes | Excel Discussion (Misc queries) | |||
userform textboxes again | Excel Programming | |||
userform textboxes | Excel Programming | |||
add numbers in textboxes on userform | Excel Programming |