Mandatory input in Excel

G

Gord Dibben

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 Entry 2
user input recorded twice on excel sheet 7

Top