Click here to Skip to main content
15,888,351 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
I am writing a Diploma Thesis with a group

To manipulate a Cell within an excel sheet we use the Excel.DocEvents_SelectionChangeEventHandler

C#
public Excel.DocEvents_SelectionChangeEventHandler AssignSelectionChanged;

[...]
C#
AssignSelectionChanged = 
  new Excel.DocEvents_SelectionChangeEventHandler(SelectionAssignChange);
_XlBook.Worksheets[1].SelectionChange += AssignSelectionChanged;

For the first few seconds everything works perfectly and our SelectionAssignChange method is being called via the event.
C#
private void SelectionAssignChange(Excel.Range target)
{
   [...]
}

But after some time (differs from try to try) the program just ignores this method and no further cells with dropdowns are created.

Imagine it like
Dropdown Enter
Dropdown Enter
Dropdown Enter
Dropdown Enter
Dropdown Enter
5 seconds passed
Nothing Enter
Nothing Enter
Nothing Enter

Hope any of you can help me!

Cheers
Posted
Updated 25-Jun-13 2:43am
v2
Comments
Rafluk 26-Oct-13 2:30am    
Hi,

I have exactly the same problem. Have you found a solution?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900