Detect if cell is in 'editing' mode

[mkgan]

Hi,
I'm doing the vba programming for excel where I added a button to the excel, and when user click on the button, it will trigger my function.

My question is: if currently there is a cell been focused, how can I know whether that is in the 'editing mode' (ie, focus on that cell and double click on that) or merely 'focus' on that cell? Any of the excel object property for this?

Thanks in advance.

[Leith Ross]

Hello Mkgan,

Excel won't allow you to click your button when a cell is being editing. This event is not exposed through VBA. It is an internal event within Excel.

Sincerely,
Leith Ross