Currently i'm using input box but i have some problems,
see i have sales field,
Then in my input box i take vsales,
then based on that value i have to select all the sales grater than vsales and adjust whole sheet based on that selection criteria. but currently it don't happen. i have to select all sales after set vsales value.
Also inputbox UI editing is difficult. If you can pls send me a doc to learn input box UI enhancements. Also please give me a suggestion to my question
I still claim that you should avoid macros. And you should use an Input box. A pop-up is not easier for a user to manage.
You can do it the following way:
1) Use an Input box for your vSales variable.
2) Goto Document properties - Triggers
3) Mark your vSales under "Variable event triggers"
4) Add Action "Select in field" and add the appropriate search string.
look at the attached application.
Hope it helped.
In-order this to work you must at-least select one value from the list box.
124047.qvw 144.2 K