• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Automatically Error Showing the message

Sarankbm

New Member
Hi Friends,

I need your help.Actually we have one excel sheets. Column 'A' and Column 'B' is mandatory column. but Column 'B' user enter the information automatically showing the error message box. we should not use the button or shortcut key.

Regards,
Saran.K
 

vletm

Excel Ninja
Sarankbm
Have You tried to use 'Data Validation' with column-B?
If would show message box without any macros.
Or
It would be more clear if You could create a SAMPLE file and upload it here.
 

Sarankbm

New Member
Sarankbm
Have You tried to use 'Data Validation' with column-B?
If would show message box without any macros.
Or
It would be more clear if You could create a SAMPLE file and upload it here.
]

Hi Vletm,

Thanks for your response.No, i don't want data validation concept.i just need 'B' Column we enter the information something the same row 'A' Column is empty that time we need error message. like this Please fill the 'A' Column

Regards,
Saran.K
 

vletm

Excel Ninja
Sarankbm
As You are asking in Excel-forum,
next possible would be to protect Your column-B.
Then cannot even select that column ... and as well as no need to get any messages.
Why to let users do something, if You can prevent that?
 
Top