RE: Executing Macro Help

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 work***?

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?




"alexdetrano@xxxxxxxxx" 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 ***.
However, this is a problem if I change worksheets and then change the
scenario, as it updates the values on that ***. 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 work*** 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 work*** and have it still execute the macro?

Any help would be greatly appreciated!


.