I would like to know how to set default selection in a list box whenever a sheet is opened.
for e.g., my list box has following values - Alpha, Beta, Gamma. Whenever I open my sheet with this list box I want , 'Alpha' to be selected by default.
Is this possible ?
Or else
If you want for particular sheet then follow like this
Right Click on Sheet--->Sheet Properties---->OnActivate Sheet--->Click on Add Action--->Add--->Action Type-
" Selection "--->Action- "Select in Field"--->Click Ok--->Field - Enter " Field Name " ---> Search String - Enter " Alpha "---> Ok--->Ok
Now whenever you open or move to this sheet by default, list box value " Alpha " will be selected.
Hope it helps!!
Yes it is possible... Please follow below steps:
Click on Settings
Select Document properties
Click on 'Triggeres' tab
Select 'OnOpen' from Document Event Triggers
Click on Add Action
Select 'Select in field' under Actions
In the field type your fieldname (Example: Type)
in the Search String box type Alpha
Click Ok.
Click Ok.
Hope this helps..
Hi Akanksha,
select one value in list box and open properties of list box in general check Always one selected value. !
Hi
Yes, it is possible.
On List box select " Alpha " ---> Right Click ----> Properties--->General Tab--->Enable " Always One Selected Value " ---> Ok
Whenever you open qv application by default it will make selection on " Alpha "
Hope it helps!!
Or else
If you want for particular sheet then follow like this
Right Click on Sheet--->Sheet Properties---->OnActivate Sheet--->Click on Add Action--->Add--->Action Type-
" Selection "--->Action- "Select in Field"--->Click Ok--->Field - Enter " Field Name " ---> Search String - Enter " Alpha "---> Ok--->Ok
Now whenever you open or move to this sheet by default, list box value " Alpha " will be selected.
Hope it helps!!
Thank you, it worked
Thank you for your responses.
Hello Priya,
If it answered your question can you close the thread by selecting one answer as correct and any other you think are helpful.
Glad to Help!!