How do I find the currently selected Scenario?

  • Thread starter Thread starter intet.nyt
  • Start date Start date
I

intet.nyt

Hi,

Maybe this is a simple thing, but I don't seem to be able to track it
down. I have an Excel sheet with a couple of Scenarios defined. I am
trying to implement some VBA functions where I need to know which
Scenario is currently selected. Does anyone know how I determine the
active Scenario from VBA?

Any help will be greatly appreciated. Thanks in advance.

Best regards.
 
hi, (?)
Maybe this is a simple thing, but I don't seem to be able to track it down.
I have an Excel sheet with a couple of Scenarios defined.
I am trying to implement some VBA functions where I need to know which Scenario is currently selected.
Does anyone know how I determine the active Scenario from VBA?
Any help will be greatly appreciated. Thanks in advance.
Click to expand...

this code line returns a null string ("") if no scenario is active/selected/... or, the name of current scenario:

application.commandbars.findcontrol(id:=1737).text

hth,
hector.
 
Hi Hector,

Thank you so much for your answer - it was exactly what I was looking for.

BTW - sorry for not replying earlier; I have been away from home for a period, and first saw the answer today.

Thanks again!

Best regards

Lasse



H?ctor Miguel wrote:

hi, (?
01-Feb-10

hi, (?

this code line returns a null string ("") if no scenario is active/selected/... or, the name of current scenario

application.commandbars.findcontrol(id:=1737).tex

hth
hector.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .Net Tips and Tricks No. 26
http://www.eggheadcafe.com/tutorial...be30-cde5d852348d/dr-dotnetskys-cool-net.aspx
 
hi, (?)


this code line returns a null string ("") if no scenario is active/selected/... or, the name of current scenario:

application.commandbars.findcontrol(id:=1737).text

hth,
hector.
Click to expand...

Hello again,

Now another problem has arisen. When I call the code you mention, I
get a new error:

-------------------
Run-time error '-2147467259 (80004005)':

Method 'Text' of object '_CommandBarComboBox' failed.
-------------------

What can be?

Thanks in advance.

Best regards,
Lasse
 
Hello again,

Now another problem has arisen. When I call the code you mention, I
get a new error:

-------------------
Run-time error '-2147467259 (80004005)':

Method 'Text' of object '_CommandBarComboBox' failed.
-------------------

What can be?

Thanks in advance.

Best regards,
Lasse
Click to expand...

Hello again,

I actually found out myself; the reason was that the button I used to
trig the function had the property "TakeFocusOnClick" set to "True".
When I changed that to "False", the problem disappeared.

Best regards,
Lasse
 
Back
Top