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