Hi.

I'm using help list, to allow user, to select the value from presented list. I'm populating few cels with such help lists.

My issue is, that they execute right after I use Range.formula = "=HelpList()" and I want them to be executed when user enters data to the cel.

Is it possible, not to execute the HelpList right after the assignment ?

In steps:
1. Range.formula = "=HelpList()" - do not execute the HelpList
2. User enters data to the field - execute HelpList