Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a list box on a sheet with Selection Style Override set to "Windows Checkboxes".
How would I set this checkbox as "checked" when the sheet is initially loaded?
Thanks
Try this way
Settings - General - Under "Selection Appearance" you can change..
Is that under Settings -> Sheet Properties -> General? I don't see "Selection Appearance".
Is it possible to do this programmatically (ie in macro)?
Can you help us your intend?
Basically I have four checkboxes (list box) on the screen. When this screen is loaded or when the user clicks this tab/sheet, I want the first two checkboxes checked by default. This is what I want to accomplish.
I think you need OnActivateSheet() trigger using FieldName and Recipe for search string as
='(' & FieldValue | FieldValue2 & ')'
Thanks for responding. I am still exploring various options and reading other posts in this forum. Here's the link and you actually commented on it last year.
List Box with default selection
There is a sample "2307770.qvw" from Clever Anjos. Where is the code that actually does the default selection?
In this case, "No Information" is the default. I looked at Settings -> Document Properties -> Triggers, I am not
seeing any code which handles this. Do you know where this code or logic is being stored in?
I believe it has been locked using Lock prompt and then Selection to each then once we clear it will be locked. And then to clear all you need to select option called "Unlock and Clear All"