Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone, I'm trying to create a spreadsheet with a lot of data that will
be entered by someone...I want to do this in forms mode so that data entry
person is less likely to have errors.

I'm wondering if I can create this on one spreadsheet and have the data
being entered go to a hidden spreadsheet? Also, can I add drop down menus to
forms?

thanks.
 
Jules

"Forms" means what?

UserForm or Data>Form or just a range of cells?

You can use Data Validation Dropdown menus for users to select pre-set items
into cells.

If you employ a UserForm through VBA you can designate where the entered data
winds up.

For more on UserForms see Debra Dalgleish's site

http://www.contextures.on.ca/xlUserForm01.html


Gord Dibben MS Excel MVP
 
Thank you!
--
Jules


Gord Dibben said:
Jules

"Forms" means what?

UserForm or Data>Form or just a range of cells?

You can use Data Validation Dropdown menus for users to select pre-set items
into cells.

If you employ a UserForm through VBA you can designate where the entered data
winds up.

For more on UserForms see Debra Dalgleish's site

http://www.contextures.on.ca/xlUserForm01.html


Gord Dibben MS Excel MVP
Click to expand...
 
Back
Top