Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combo box
if i set up a combo box in worksheet 2 can i have the name a select in this
combo box put into a cell in worksheet on. thanks for your help |
#2
|
|||
|
|||
Yes you can.
Worksheets("Sheet1").Range("A1") = Worksheets("Sheet2").ComboBox1.Value should do the trick. Mangesh "Monty" wrote in message ... if i set up a combo box in worksheet 2 can i have the name a select in this combo box put into a cell in worksheet on. thanks for your help |
#3
|
|||
|
|||
Thanks
this worked . however i have decided to use cell validition and transpose. "Mangesh Yadav" wrote: Yes you can. Worksheets("Sheet1").Range("A1") = Worksheets("Sheet2").ComboBox1.Value should do the trick. Mangesh "Monty" wrote in message ... if i set up a combo box in worksheet 2 can i have the name a select in this combo box put into a cell in worksheet on. thanks for your help |
#4
|
|||
|
|||
Thanks
this worked . however i have decided to use cell validition and transpose. "Mangesh Yadav" wrote: Yes you can. Worksheets("Sheet1").Range("A1") = Worksheets("Sheet2").ComboBox1.Value should do the trick. Mangesh "Monty" wrote in message ... if i set up a combo box in worksheet 2 can i have the name a select in this combo box put into a cell in worksheet on. thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Combo Box | Excel Worksheet Functions | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
extract data from combo box n use it in SQL | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions |