macro Excel problem link cells with Data-Validation option

  • Thread starter Thread starter srdjan.radnovic
  • Start date Start date
S

srdjan.radnovic

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.
 
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
 
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
Click to expand...

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
 
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
Click to expand...

Sorry Hutch !!!!!

I am so stupid.
1. How can I
"Select both cells and name that range Loans." ?
Click to expand...

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

Thanks very much !!!
 
Hello, I have a similar problem: i would like to link a macro button to a drop-down menu (data validation). Ideally I would select an option from the drop-down menu and then press the button, which based on the choice produces its output. Could anybody help me with this?

Thank you!
 
Back
Top