Formula: =epmselectmember() via VBA

[ChristianSass]

Hi,

normally the user can trigger an "EPM - Member selector" window with double on cell which contains =epmselectmember() formula.

I would like to Trigger this function with VBA. Unfortunately this doesn't work. I've tried "application.doubleclick" without any outcome and I couldn't find anything on the web.

Is their any hint from the community to this issue?

Thx

[former_member186338 · Accepted solution]

Hi Christian,

Use API OpenFilteredMemberSelector

Vadim

[ChristianSass · Accepted solution]

Thank you!