how to simulate selection of line in the data input forms using HypSetActiveMember
SummaryTo update parameters in the data input form using VBA(Enhancement Request)
To update parameters in the data input form, I need to clear selections first. For instance, I have a form that has “Region 1” selected in Management dropdown and “Product 1” selected in Service Line dropdown, and I want to change it to “Region 2” and Product 2” respectively. I can’t just open Service Line selector and select “Product 2”, as this product may not be available for Region 2; I need to clear selection first.
For manual input, I just open a dropdown and select “<Clear Selection>” from the list. How do I perform the same action using VBA?.