macro Excel problem link cells with Data-Validation option

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

srdjan.radnovic@gmail.com - 25 Mar 2008 16:16 GMT

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.

Reply to this Message

Tom Hutchins - 25 Mar 2008 17:36 GMT

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

> HI,
>
[quoted text clipped - 19 lines]
>
> Srdjan R.

Reply to this Message

srdjan.radnovic@gmail.com - 26 Mar 2008 09:49 GMT

On Mar 25, 5:36 pm, Tom Hutchins
<TomHutch...@discussions.microsoft.com> wrote:

> One way...
>
[quoted text clipped - 39 lines]
>
> > 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

Reply to this Message

srdjan.radnovic@gmail.com - 26 Mar 2008 10:20 GMT

On Mar 26, 9:49 am, srdjan.radno...@gmail.com wrote:

> On Mar 25, 5:36 pm, Tom Hutchins
>
[quoted text clipped - 55 lines]
> 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 !!!

Reply to this Message