Disallow Special Characters, Certain Numbers Using Data Validation through VBA
How do I Disallow Special Characters, Certain Numbers Using Data Validation through VBA?
I want to prevent the Range of Numbers beyond 6 in a particular Column F..
If I have a formula for not repeating or preventing duplicate entries in a Column, How would I do that using VBA?
BUt actually I did not follow the example in it using the Formulas:
What does this imply?
And the Tool Tip or the Data Validation Text which appears can that be programmed too using VBA to change the colour to the TEXT making it BOLD or even get Dynamic Text..!!