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
Bookmarks