Inputbox Auto Close

  • Thread starter Thread starter MAS
  • Start date Start date
M

MAS

I am 'Almost' certain the answer is no but need to check..

I have an inputbox that is setup to accept the contents of whichever cell
the user clicks on. Is there any way to get the inputbox to close once the
user has selected a cell or is the only option to hit the ok button or Enter
key ?

M.
 
MAS said:
I have an inputbox that is setup to accept the contents of
whichever cell the user clicks on. Is there any way to get
the inputbox to close once the user has selected a cell or
is the only option to hit the ok button or Enter key ?
Click to expand...

Is this for your own use or are you designing something other people would
use? If the latter, this would be a VERY BAD design element. People are apt
to make mistakes, not least of which clicking on the wrong cell from time to
time. If the first click were always accepted, how would users correct such
mistakes?
 
I have catered for incorrect selection of cells in the code and even if all
that failed the input only goes to populate a new comment so the final catch
all is that they delete the cell and redo the selection.

So it appears I am right in my belief that there is no way to close an
inputbox without clicking on ok or hitting the enter key so lets look at it
from another angle.

Is there a way to other than inputbox to prompt the user to click on the
desired cell and once a selection is made for the code to move on to the
next stage ?

MAS
 
Back
Top