Programmatically move from an open cell to a different one

[sclarke2010]

Hi, I am trying to programmatically move to a new cell if someone is is the middle of entering text, numbers, formulas, etc. The reason for this is that this 'open/input' cell stops the worksheet from being saved and closed. So is there a way of saying programmatically (in C# and .net) that if a cell is open ie someone hasn't clicked on another cell after entering info, then move to the next cell or cell A1 (any other cell will do)?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[Norie]

What do you mean by an 'open' cell?

How are you copying/saving and why is this stopping you doing so?

I know that you can't execute VBA when a cell is in edit mode, not sure what difference, if any, using .NET or C# would make.

What is it you are actually trying to achieve?

 

[sclarke2010]

Hi Norie, Thanks for getting back to me. Yes, edit mode is a better description.

Basically when a worksheet has a cell in edit mode (ie when someone double clicked on a cell and started entering text, etc), .net and C# isn't able to get a reference to it. So all that I want to do is programmatically move away from this cell to any other cell, or an equivalent of hitting return on a cell in edit mode. In other words when this part of finished no cell in any wprksheet should be in edit mode.

Regards, Stephen

 

[Norie]

Stephen

Did you not see what I said about VBA and edit mode?

Why would you want/need to save a workbook when a user is in the process of editing/entering data?

I don't know about you but it would freak me out a bit if all of a sudden focus moved to another cell while I was typing something.ll.

My laptop is bad enough for that sort of thing, though that's probably me just being fat-fingered.

 

[sclarke2010]

Hi Norie,

Yes, I read your replies about VBA and edit mode.

This may well be the case with C# and .net, and is what I am trying to find out and do if possible. Basically, I am trying to find a way of saving everything for a user when they are not at their desk ie if they just left one worksheet cell in edit mode and went home for the day, and this can't be saved programitically when a cell is in edit mode. So just need any way of programmatically returning or moving to a cell beside the edit cell.

 

[sclarke2010]

Anyone know if this is possible ie to programatically (I'm using C# '08 and .net '09), move from an Excel cell that is in edit mode (ie someone entering or updating info in the cell) to another cell? Any other cell would do (eg A1, cell beside current cell, etc).

Thanks,

Stephen