Mandatory input in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
Only by not allowing the workbook to be saved or closed before the cell is
filled in.

This would also require that users enable macros which opens a second can of
worms.

i.e. What do you do if users do not enable macros.

Anything else relies strictly on educating your users.

You could just place a message formula in the cell like

=if(and(A1<>"",B1=""),"Please enter a value in B1","")

See this google search thread for some code if you wish to go that way.

http://snipurl.com/16bvu

I included several posts from Dave Peterson so browse through them.


Gord Dibben MS Excel MVP

On Mon, 1 Jan 2007 18:47:15 -0800, Vinesh Rao <Vinesh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
How to make an input in a cell mandatory without leaving it blank 3
Mandatory Input of a Cell 2
Excel Making a cell Mandatory 9
Creating a spreadsheet with mandatory fields 0
How do I make a specific cell mandatory? 2
Mandatory Cell completion for multiple worksheets in a workbook 0
Mandatory Cell Entry 2

Back
Top