activate list

krpatel · Mar 5th 2017

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

**pike** · Mar 5th 2017

Re: activate list

hi krpatel,
Not to sure what you are asking can you attach a sample workbook to help explain

krpatel · Mar 6th 2017

Re: activate list

i would you attach sample file sheet one list item and sheet 2 create list

when i activate cell A5 in sheet 2 then list activate in cell A5 or when i activate cell A10 then list activate in cell A10.

**pike** · Mar 6th 2017

Re: activate list

Hi krpatel,
do you mean you can only select a value once for the named range?

krpatel · Mar 8th 2017

Re: activate list

no.
only given range will be allow enter value or move cursor by keyboard for edit other range will be not move cursor by keyboard.move cursor by keyboard only given range only

**pike** · Mar 8th 2017

Re: activate list

Hello,
I don't understand what you mean

activate list

Participate now!

Share