Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Default View - List Box

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 ?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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!!

View solution in original post

8 Replies
trdandamudi
Master II
Master II

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..

Akina0929
Creator
Creator

Hi Akanksha,

    select one value in list box and open properties of list box  in general check Always one selected value. !

Anonymous
Not applicable
Author

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!!

Anonymous
Not applicable
Author

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!!

Not applicable
Author

Thank you, it worked

Not applicable
Author

Thank you for your responses.

vishsaggi
Champion III
Champion III

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.

Anonymous
Not applicable
Author

Glad to Help!!