Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box in Dialogue Box
Can you create a dialogue box listing:
1. Adam; 2. Joseph; 3. David; Selecting any of which shall lead to display the name in cell $A$1? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box in Dialogue Box
Faraz,
Create your combo box and format it to select the input range that contains your 3 names. In the example below they are in the top three rows of column 2. Format a cell link for the output and in the example below I've used 7,1 on sheet 1 and then attach this small macro to the combo box. The name appears in cell 1,1 Sub namechange() Row = Worksheets("sheet1").Cells(7, 1).Value Cells(1, 1).Value = Cells(Row, 2).Value End Sub Mike "FARAZ QURESHI" wrote: Can you create a dialogue box listing: 1. Adam; 2. Joseph; 3. David; Selecting any of which shall lead to display the name in cell $A$1? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box in Dialogue Box
If it is as simple as you present it, with A1 the active cell
At the menu, select Data, Validation... Allow (select List); Source: (enter) Adam,Joseph,David and OK (Other features are available- Just test them out).. HTH "FARAZ QURESHI" wrote in message : Can you create a dialogue box listing: 1. Adam; 2. Joseph; 3. David; Selecting any of which shall lead to display the name in cell $A$1? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro that can run combo boxes | Excel Discussion (Misc queries) | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
Dynamic Combo Box | Excel Worksheet Functions | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions |