LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Context-sensitive Actions pane

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Implementing Context Sensitive Help in Excel App using VBA. MGirish Excel Discussion (Misc queries) 0 January 23rd 06 04:13 PM
Context-sensitive custom menu item. Murray Excel Programming 7 December 28th 05 04:55 AM
Context sensitive help Jon Bailes Excel Programming 2 January 14th 05 01:19 PM
Context sensitive menu Mark[_36_] Excel Programming 5 March 3rd 04 01:50 PM
context sensitive help Malcolm Excel Programming 0 November 19th 03 02:00 PM


All times are GMT +1. The time now is 09:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"