Thread: Drop down box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob[_67_] Bob[_67_] is offline
external usenet poster
 
Posts: 6
Default Drop down box

It will be very appreceated if anyone can help, because I don't have a lot
of knowledge in Excel.
I was asked from my bos to build some drop down boxes.
Here is the logic:

Col A will have the drop down with values
1.Foreing
2.Pension
3.Unregulated

In Column B will be another drop down selection depending on what the user
select in col A.
If he selects in col A Foreing the drop down in col B will be FCP

KAG

Central
If he selects in col A Pension the drop down in col B will be ESOP

Stable

VEBA
If he selects in col A Unregulated the drop down in col B will change to
Charity
Common
LLC etc

Thank you for your help
--
Bob