Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Form Combo Box
Hi
In Cell A1 I have a link to a Index function that uses Indirect(A1) to look up a named range. I also am making a form, and I just want the form to choose between some names that are located in cells "Z1:Z10" of the worksheet and put the selected name in Cell A1. How do you link the combo box to cells Z1:Z10, and put your choice in cell A1? Thanks a lot for your help |
#2
|
|||
|
|||
Hi
see: http://www.contextures.com/xlCondFormat01.html -- Regards Frank Kabel Frankfurt, Germany Jeff wrote: Hi In Cell A1 I have a link to a Index function that uses Indirect(A1) to look up a named range. I also am making a form, and I just want the form to choose between some names that are located in cells "Z1:Z10" of the worksheet and put the selected name in Cell A1. How do you link the combo box to cells Z1:Z10, and put your choice in cell A1? Thanks a lot for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double combo charts - are they possible? | Charts and Charting in Excel | |||
Combo Box Showing numbers not dates | Excel Discussion (Misc queries) | |||
combo box formatting | Excel Discussion (Misc queries) | |||
Forcing Combo box entry in VBA | Excel Discussion (Misc queries) | |||
A "previous" button on a user form | Excel Discussion (Misc queries) |