Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find the currently selected Scenario?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find the currently selected Scenario?
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. 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find the currently selected Scenario?
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).text 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/tutorials...-cool-net.aspx |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find the currently selected Scenario?
On Feb 2, 5:51*am, "Héctor Miguel"
wrote: 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. 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. 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find the currently selected Scenario?
On Feb 22, 10:34*am, "
wrote: On Feb 2, 5:51*am, "Héctor Miguel" wrote: 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. 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. 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, 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find out how many rows I have selected? | Excel Discussion (Misc queries) | |||
VBA: How do I find a value within a selected range? | Excel Programming | |||
Find Selected value to .Offset from | Excel Programming | |||
how to find if diagram is selected? | Excel Programming | |||
Find out what is selected for AutoFilter | Excel Programming |