Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Data Validation

Resolved · Low Priority · Version 2010

Reply Thu 12 Jan 2012, 16:36Delegate Richard said...

Richard has attended:
Excel Advanced course

Data Validation

Can you ensure a cell in a table is completed by a user? (ie error message appears until cell is not left blank)

For upcoming training course dates see: Pricing & availability

Reply Fri 13 Jan 2012, 12:12Trainer Rodney said...

RE: Data Validation

Hello Richard,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding ensuring a cell is input by a user. The Data Validation rules do not provide for this type of control, however, this can be done using code produced in VBA (Visual Basic for Applications) which is outside the parameters of this forum post.

We do deliver training on VBA and you may be interested in taking this course to further develop your Excel skills.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Fri 20 Jan 2012: Automatically marked as resolved.

Excel articles

· Do You Need To Run Excel 2007 In Compatibility Mode?
· Excel Offers A More Relaxing Way To Work Out
· Say It With Ribbon
· Conditional Formatting: A Useful Feature Of Excel
· Break The Mystery Of Code With Excel Macros

Please browse our web site to find out more about
excel training microsoft and other Microsoft training courses.

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips