View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 422
Default 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?