How to reset field selection

[#1]

Hi,

I've seen something in an application and didn't know how to do it.

We have two sheet tabs (tab1, tab2). In each tab, there is a field selection (field1 and field2). The required behavior is like the following:

1. go to tab1. Field1 ponits to value A1 as a selection by default. The user changes the selection a value say 'A2'.

2. go to tab2. Filed2 points to value B1 by default. The user changes its selection to 'B2'.

3. Now, when the user clicks on tab1, Filed1 selection automatically points back to the value 'A1'.

How can I do that?

[jonathandienst]

If I understand your correctly, you could use a sheet OnActivate trigger, with a Selection action.

Click on Properties | Triggers for tab1 and Add Action(s) for OnActivate sheet. Click on Add and choose Selection | Select in Field to set Field1 to A1. Do the same with tab2.

Jonathan