Ok, so I'm trying to create a sign up sheet for different users and I want to make sure that each field is filled in. How do I force the user to enter in content into each cell before they tab to the next column? I know that this can be done in Access, but I'm no sure how to do it in Excel. Please help! Thanks!
2007-03-08 10:15:02 · 3 answers · asked by dOM 1 in Computers & Internet ➔ Software
The problem with this approach is many users deactivate macros as default. Some antivirus software will treat all macros as potential virus.
Suggest you try something simple
1. Use conditional formatting. Format a different color if entry is blank.
2. Use simple if function to flag. eg
=if(or(isblank(a1),isblank(a2)..),"Missing Input","U may proceed")
3. Use Excel built-in form tools to catch user inputs errors.
It is also very difficult to deal with "users in the wild" who use Excel in ways which will break your macros. There is always some safeguards you missed out.
2007-03-08 13:24:41 · answer #1 · answered by unnga 6 · 0⤊ 0⤋
a million. enter a nil contained in the cellular. 2. suitable click that cellular then cellular format. 3. flow to custom on the determination tab. 4. spotlight the 0 and contained in the variety column variety in 00 and close.
2016-12-05 10:35:16 · answer #2 · answered by ? 4 · 0⤊ 0⤋
i am sure that can be done.. but dont remember how to do that..
did you check this site www.excelgoodies.com , i am sure u will get a solution there
2007-03-09 04:06:38 · answer #3 · answered by sam e 2 · 0⤊ 1⤋