ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   .Net Automation Add-In - Execution Always Ends in Edit Mode (https://www.excelbanter.com/excel-programming/375076-net-automation-add-execution-always-ends-edit-mode.html)

Matthew Wieder[_3_]

.Net Automation Add-In - Execution Always Ends in Edit Mode
 
I have written a C# Automation Add-In for Excel. Everything is working as
desired with one exception. I have a doubleclick handler that brings up a
form to edit the formula in that cell. However, when the form is closed
(either because the user made a change and clicked OK, or clicked Cancel)
Excel always enters edit-mode on that cell. I have to programatically then
select the neighboring cell and then reselect the current cell so that it
appears to the user to not have entered edit mode. It was my understanding
that the "ref bool bCancel" param on the doubleclick handler was to address
this issue but whether I set bCancel to true or false, I cannot avoid this
problem. Help?
thanks!





All times are GMT +1. The time now is 12:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com