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.

macro Excel problem link cells with Data-Validation option
 

One way...

For your dropdown list in A1, use data validation. Select List in the the
Allow box and enter the 3 options in the Source box: Loans, Cards, Ebanking

Somewhere in your workbook (maybe on another sheet, which you can hide),
create 3 named ranges with names that exactly match the options in A1. For
example, enter Retail in a cell and Corporate in the cell below it. Select
both cells and name that range Loans. Create a Cards named range and an
Ebanking named range the same way.

On starting sheet, in B1, select Validation from the Data menu. Select List
from the Allow box, and in the Source box enter: =INDIRECT($A$1)

Now B1 will list the values in the named range selected in A1. Hope this
helps,

Hutch

" wrote:

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.

macro Excel problem link cells with Data-Validation option
 

On Mar 25, 5:36 pm, Tom Hutchins
wrote:
One way...

For your dropdown list in A1, use data validation. Select List in the the
Allow box and enter the 3 options in the Source box: Loans, Cards, Ebanking

Somewhere in your workbook (maybe on another sheet, which you can hide),
create 3 named ranges with names that exactly match the options in A1. For
example, enter Retail in a cell and Corporate in the cell below it. Select
both cells and name that range Loans. Create a Cards named range and an
Ebanking named range the same way.

On starting sheet, in B1, select Validation from the Data menu. Select List
from the Allow box, and in the Source box enter: =INDIRECT($A$1)

Now B1 will list the values in the named range selected in A1. Hope this
helps,

Hutch

" wrote:
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.

I have two questions:
1. How can I
"Select both cells and name that range Loans." ?

and

2.When I enter in B1 (On starting sheet) =INDIRECT($A$1) Excel show
error THE SOURCE CURRENTLY EVALUATES TO AN ERROR. DO YUO WISH TO
CONTINUE?

Sorry and thanks,
Srdjan

macro Excel problem link cells with Data-Validation option
 

On Mar 26, 9:49 am, wrote:
On Mar 25, 5:36 pm, Tom Hutchins



wrote:
One way...

For your dropdown list in A1, use data validation. Select List in the the
Allow box and enter the 3 options in the Source box: Loans, Cards, Ebanking

Somewhere in your workbook (maybe on another sheet, which you can hide),
create 3 named ranges with names that exactly match the options in A1. For
example, enter Retail in a cell and Corporate in the cell below it. Select
both cells and name that range Loans. Create a Cards named range and an
Ebanking named range the same way.

On starting sheet, in B1, select Validation from the Data menu. Select List
from the Allow box, and in the Source box enter: =INDIRECT($A$1)

Now B1 will list the values in the named range selected in A1. Hope this
helps,

Hutch

" wrote:
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.

I have two questions:
1. How can I
"Select both cells and name that range Loans." ?

and

2.When I enter in B1 (On starting sheet) =INDIRECT($A$1) Excel show
error THE SOURCE CURRENTLY EVALUATES TO AN ERROR. DO YUO WISH TO
CONTINUE?

Sorry and thanks,
Srdjan

Sorry Hutch !!!!!

I am so stupid.

1. How can I
"Select both cells and name that range Loans." ?

Easy - Select two cells - under Font list in Name box enter loans,
cards, ebanking, dependency which range is selected.

Thanks very much !!!