View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] SaxonFSU@gmail.com is offline
external usenet poster
 
Posts: 1
Default Can I make a data entry box?

Bonnie,

Perhaps you selected Table/Form
Excel has a built-in data form. Click Table and then select form.

Hope this was it.


On Jan 31, 1:26 pm, gobonniego
wrote:
I'm not a new user, but sometimes I just don't know the names for things.
I'm making a worksheet for low level users and I'm trying to simplify it.
Most of the data is a choice between 3 things and then typing in a name.

I swear, some time in another life I set up a worksheet with a "data entry
box." The box popped up, you clicked off or entered the stuff, clicked "OK"
and the data was posted to the right cells; but you didn't have to tab to
each cell.

Is this possible? Am I dreaming? Was my other life in Access? Can't for
the life of me figure it out or remember what it was called. (Help is so
unhelpful sometimes.)

Bonnie