For a better experience, please enable JavaScript in your browser before proceeding.I have a large table with data spread across rows and columns.
I want to basically create a cross hair when I actively move cells. I found this VBA code online, it works well but the only problem is that it deletes currently highlightedcolored cells but leaves the Borders as it is when the macro runs on the sheet. Where I can use a Highlight but it doesnt delete the existing highlightedcolored cells OR Where I can use a Border but it doesnt delete the existing bordered cells. Check the excel file I have attached and read the notes in the sheets. Its a Rick Rothstein response to a somewhat similiar question a couple years ago. What I mean is go and enter a value in a cell and press Enter. Sheet 2, is great too but the crosshair doesnt move as you keep entering values into a different cell. E.g. take cell a1. Ids there any code there To find out what event handlers there are ( sheet or otherwise), in the left hand dropdown at the top of the main code pane in the VBE, choose Workbook, then in the right and dropdown youll see a list of event handlers. I believe running any macro that does anything to a sheet automatically clears the UNDO stack. Ill keep watching this thread in hopes of finding out why (or how) in post 8 p45cal indicates he was allowed to undoredo. I could not find when you said then in the right and dropdown youll see a list of even handlers. Another way to get into ThisWorkbook object is to right click a tab, View Code. I think you could modify this to work with the SelectionChange, if at the start you added an argument to stop if more than 1 cells are selected.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |