Help with list box and multiple tabs.

[#1]

Hi I have a list box with multiple values in there.Ex I have a list bocx with Risk,Sles,Revenue,Finance etc and I have different tabs for each of them.So whne I select Risk in the list box can it take me to Risk tab and when I selct Sales in list box can it take me to Sles tab and so on.

Thank in adavance.

[yduval75]

Hello,

In the script, you create a field "SheetID" with the Sheet ID corresponding to each value of the field in your listbox.
then you can create a button near to your list box. In the action of your button, you select Layout / Acivate Object and you put the field "SheetID"

The action button will change according to your selection in your list Box

Best Regards,

Yoann

[#3]

Thyank for your reply.Can you please attach an example of this.I am kind of confused.It will be of great help for me as it is an urgent requirement.

Thanka a bunch.

[tresesco]

May be like attached sample?

[#5]

I cannot see the attached documnet.Can you please post it again.Thanks.

[tresesco]

Now, is it visible?

[#7]

Nope.

[#8]

Here you got, somehtin like this?

Regards!!

[tresesco · Accepted solution]

See if this can help : Note: (F2 is the field name)

[#10]

Awesome.This is exactly what I wanted.Thank a bunch.