Simple entry question

Nath

New Member
Joined
Dec 18, 2005
Messages
7
I have 2 simple quetions
1. Is it possible to make a cell required field depending upon data in another cell. The idea is to prevent operator from carelessly skipping required fields.
2. is it possible to have a calendar pop up in date field .
Any suggestions will be greatly appreciated.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

RAM

Well-known Member
Joined
Oct 4, 2004
Messages
1,862
As for number 1. you could present some more data how you worksheet looks like and what is needed.

RAM
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,706
Members
412,481
Latest member
nhantam
Top