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?

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?

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?