Ensure that you are using the correct formula and remove unnecessary
blanks from the sheet. Also, check the Ignore blanks in data
vlaidation box.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
From: B Sharma
> Sent: Friday, December 02, 2011 10:52 PM
> To: MS EXCEL AND VBA MACROS
> Cc: rajanverma1...@gmail.com
> Subject: $$Excel-Macros$$ Data validation not working properly
>
>
> Dear Excel Experts.
>
> I have created a drop down list using data validation
l-Macros$$ Data validation not working properly
Dear Excel Experts.
I have created a drop down list using data validation and the source
of the list is a dynamic range created at another sheet.
I have checked "Show error alert after invalid data entered"
Its working fine and showing the source l
Dear Excel Experts.
I have created a drop down list using data validation and the source
of the list is a dynamic range created at another sheet.
I have checked "Show error alert after invalid data entered"
Its working fine and showing the source list in the drop down list but
it also accepts an
