View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] srdjan.radnovic@gmail.com is offline
external usenet poster
 
Posts: 4
Default macro Excel problem link cells with Data-Validation option

HI,

I would like link cells with macro in Excel (if this is good
descriptions):
In cell A1, I have list od three options. Dependensy I choose some
option from the list, than in B1 I must have correct list.

Example,
in A1 I have list (validation cell) of three options (loans, cards, e-
banking)
When I choose options loans from validation cell list, than in B1 will
show validation list with two option (Retail, Corporate).

When I choose options cards from validation cell list, than in B1
will show validation list with two option (VISA, MASTER).

When I choose options e-banking from validation cell list, than in B1
will show validation list with two option (Retail e-banking, Corporate
e-banking).

If someone know, thanks

Srdjan R.