Combo Box in Dialogue Box

F

FARAZ QURESHI

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?
 
M

Mike

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
 
J

JMay

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
 
Top