LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I link a conditional list in MS Excel Data validation? Mig Excel Discussion (Misc queries) 2 March 6th 08 11:57 AM
Data Validation dialog box NO in-cell dropdown option Paul B Excel Discussion (Misc queries) 3 October 19th 06 12:16 AM
Tricky problem in Data validation - Excel 2003 smadhuranath Excel Discussion (Misc queries) 1 July 18th 06 09:10 AM
Data Validation List Option Affecting Other Cells? tomrobs Excel Worksheet Functions 0 November 5th 04 07:13 PM
Data Validation List Option Affecting Other Cells? tomrobs Excel Worksheet Functions 1 November 5th 04 04:26 PM


All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"