Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I posted this question on the VSTO forum and they suggested I also post here.
I have an Excel workbook that contains two named Ranges: OrderDate and ShipDate. I'm using it in a VSTO solution with an Actions pane. When I select either of these cells, I want the Actions pane to display a user control that contains a label and a DateTimePicker control. I want the user control to show up in the Actions pane only when one of these cells is selected, so I have code on the ranges' Selected and Deselected event handlers to add (on Selected) or remove (on Deselected) the control . I'm not including the code here, but you can see it on my original post if you like: http://forums.microsoft.com/MSDN/Sho...iteID=1&mode=1 The solution works fine when I put my cursor on OrderDate and then move to ShipDate. It also works fine when I move from any other cell to either OrderDate or ShipDate. The solution does NOT work when I move from ShipDate to OrderDate. The control is removed but not added. I added some message boxes and it looks like the events are firing in the wrong order: The OrderDate_Selected event fires BEFORE the ShipDate_Deselected event. (In the OrderDate to ShipDate scenario the events fire as I would expect, OrderDate_Deselected and then ShipDate_Selected.) Is this expected behavior? Just so you know, there's nothing special about the workbook. I was able to recreate on a completely vanilla new workbook/project. Thanks, --jan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Implementing Context Sensitive Help in Excel App using VBA. | Excel Discussion (Misc queries) | |||
Context-sensitive custom menu item. | Excel Programming | |||
Context sensitive help | Excel Programming | |||
Context sensitive menu | Excel Programming | |||
context sensitive help | Excel Programming |