Default value set on Listbox and Calendar Object

[vipingarg23]

Hi Team,

I have one listbox object and one calendar object. I want that when I open qvw file, default value should be selected for both object.

I am applying trigger but it is not working.

For listbox:

Sheet Properties->Triggers->OnActiveSheet->Select in field...

field = name of field

search string=value(I need to search SEPT)

I am doing same for calendar object also but it is not working for both.

[sunny_talwar]

Would you be able to share a sample qvw where you might have tried this to see what might be an issue?

[vipingarg23]

Please find the attachment for listbox. I need JAN as default selected value. I have applied trigger which is not working

[mayankraoka]

Hi Vipin,

This can be achieved by using on open trigger.

PFA application.

Regards,

Mayank

[mayankraoka · Accepted solution]

On activate sheet will work if you move from main sheet to Sheet1.

The other way for this could  be save the application by default selections you want.

Regards,

Mayank

[sunny_talwar]

I don't see any triggers... did you attach the right file? Also, do you always want JAN to be selected? or this can change based on another condition?

[sunny_talwar]

My bad, I see it now.... You need to remove the = sign from your field name

[vipingarg23]

Yes..Right, it is working in this example. But I am not sure why it is not working in my application once I am applying the same.

[vipingarg23]

Good catch Sunny...I was again doing the same mistake. Now it is working fine after removing = sign. Thanks Sunny and Mayank for the help.

[vipingarg23]

Can anyone help me for calendar object also.