how to use triggers and main difference just give one example application

[#1]

Dear all,

Please send on application about triggers .

Regards & Advance

Babu

[MK_QSL]

Please check enclosed file....Trigger is whenever you open the file, the trigger will reload the script...

For this you need to go to Settings - Document Properties - Trigger - OnOpen

[#3]

Thanks,

Actually i have two sheets in that two sheets have year, month, Quarter multi boxes.

1.By default first sheet  showed year values and second sheet  showed Aug month values.

when i open  then showing this. by using triggers.

[MK_QSL]

can you please upload your file?

[MK_QSL · Accepted solution]

If you want to show 2013 selected in Sheet 1...

Right Click on blank space of Sheet 1 - Properties - Triggers - OnActiveSheet - Add Actions - Add -

Selection - Select in Field

Type Year in Field

Type 2013 in Search String

Do the same for Sheet2 and select appropriate field...

Type Month in Field

Type Aug in Search String

[#6]

Thanks Manish,

in previous i was used alternate state in each sheet, finally got  answer from you it will great help full my report, this is my client requirement.