Cant click button immeditally

  • Thread starter Thread starter gkaste
  • Start date Start date
G

gkaste

After typing into a cell, I cannot click on a button right away. First
I have to hit enter(or do something to move to another cell), then I ca
click on the button. Is there any way around this? Reason being tha
this spreadsheet was designed for use by some no so computer savv
people, and when they cant click the button, I dont know what the
think will fix it, but somehow they delete something and goof up th
spreadsheet. Is there a way to change this so clicking the butto
deactivates the cell, or something like that?

Thank you
 
gkaste,

You've hit on the main issue with using a worksheet as a user form. It just
doesn't work like forms in other programs, web pages, etc. You'll just need
to train people who'll use this. Or you may have to actually make a
UserForm, with the necessary macro coding to put the data where it needs to
go. The boxes in such a form work more like people are used to. They can
click (or Tab) the cursor directly into a box, any existing data remains
(they don't have to know to use F2 or double click for Edit Mode as with a
worksheet), and can stop at any time, and all data in the boxes, as it
appears, is what they get.
 
Back
Top