Activate List

[delta]

in sheet 1 i create a list name "item Name" and they contain 50 items
in sheet 2 cell range "A5:A10" list "item Name" is shown by a validation
i want when user activate range "A5:A10" then activate list other wise deactivate

this is only by macro


▬▬▬▬▬▬▬▬▬ Mod edit : at least again post in appropriate forum !

​

 

[Monty]

Hello
Not clear...Upload file to help you.

 

[delta]

i upload file sheet 1 list name and sheet 2 create list "Item_Name".

 

[delta]

monty sir pls give solution

 

[Monty]

Am really sorry, i read your question quite few times...please make me understand what you are looking for.

 

[delta]

when user activate or select cell between cell range "A5:A10" then drop down box or list is activate or show other wise detective or hide

 

[Monty]

What do you you want to active...At the same time when do you want to deactive...Pls confirm your project.