Show sheet based on a specific list box being selected

[kschramm]

Hi.  I have been able to conditionally get a sheet to display using GETCURRENTSELECTIONS.  Is there a way to determine what list box (or boxes) a user selected on?  There is a main search window and I want to be able to display specific sheets based on which area the are searching on.  Thank you in advance.

[prabhu0505]

Objects don't have triggers but Fields do.

So for your requirement you have to figure out work around with Field trigger.