Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi..
Can any one help me how to set default selection in listbox..
Thaks.
Select the value in list box-.
list box properties->General->Always one selected value(Check box)
or you can add an action to the on activate sheet trigger to select in field;
you select your field and the desired value
if you want to select more than one value you have to put '(' & value1 & '|' & value2 &... & ')'
For doing this follow steps
1. Select any value in the list box.
2. Then go to properties and select General >> Always One value selected.
Regards
Aannd
Hi sasi..
Thanks for your reply..
Its working fine in list box .how we set same property in multibox.
Thanks.
Hi,
Do the next: right clik on that sheet and go to trigger tab.
Then, add action on ActiveSheet, click -->Add-->selection-->select in field
then select the fields above and in search string write the values of the fields.
(From Setting default values in List box)
Hope this helps.
Hi..
Can you give me example ..
Thanks.
Multibox->Properties->Presentation-
Select the field.
Always one selected Value(Check box)
Hope this help you out.
If yes, please mark as correct and close the thread.
ok right-click on the sheet and go to trigger tab
click AddAction on the OnActivateSheet Trigger then click on Add Action button
select the SELECTION action type and then select select in field
write down your field name suppose it is F1 then in the search string write down the desired values as such
='(' & value1 & '|' & value2 &')'
then click add action again and write down your second desired field and write the desired values to select by default
Put a trigger for 'section field' Pass the field name and the value you want it to be selected.
This trigger can be added to the sheet or you can add it to the whole document.