hi

a little confuse what you said.

you mean you have 2 tabs, 1 is Profits, 1 is Rev. a combo box in Profits
which will change B92 in Rev when changed.

I don't know what you mean keep focus on the worksheet?

How do you configure for this combo box to change the value in Rev B92 ?

do you use VBA code? if yes, what's your code?




" wrote:

Hi there

I've got this combo box set up so that when I pick one scenario, it
executes a macro which changes a few values on the current sheet.
However, this is a problem if I change worksheets and then change the
scenario, as it updates the values on that sheet. What I'm looking to
do is change the scenario and execute the macro to change ONLY the
values on the tab that I want?

For example, I'm in Profits worksheet and choose best scenario from
the combo box, and it changes B92 in Rev tab. Also, is there a way to
keep focus on the worksheet and have it still execute the macro?

Any help would be greatly appreciated!