ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   "deselect ?" a range or change state from edit to ? (https://www.excelbanter.com/excel-programming/306693-deselect-range-change-state-edit.html)

Mark Kubicki

"deselect ?" a range or change state from edit to ?
 
i have a set of subs that process when a cell is double clicked; they open a
window with information about the contents of the cell

the problem is:

when i close the window, the target cell is in an edit (?) state (the
vertical edit bar is visible within the text),
then when the user clicks (selects) a different cell (there may be no need
for them to edit the text in the target cell), the curser "bounces" back to
the target cell putting it ina selected, but not edit state (?? ...i think
this is what is happening ??) from this point on, a different cell can be
selected and the selection will "stick"

.... frustrating!

i would like the target cell to remain selected when the window is closed
(so the user knows where they were, but not in the edit state (so that when
the user clicks a different cell, they remain with that new choice)

thanks in advance,
mark




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

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