"deselect ?" a range or change state from edit to ?

  • Thread starter Thread starter mark kubicki
  • Start date Start date
M

mark kubicki

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
 
ah! ... moved the "cancel..." out of the sub and into the "before double
click..." and viola !!
....always, check for the obvious 1st)

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top