aravindhan_31
Well-known Member
- Joined
- Apr 11, 2006
- Messages
- 672
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi,
Could you please help with VBA or any other method to have multiple validation for one cel Cells A1:A100
User enters the Invoice numbers in these cells.
Data Validation:-
1. User should be able to enter only the words Starts with V,W & COM
if it starts with V or W then allow only 6 charectors
if its Start with COM then allow 8 charectors.
Thanks for your help in advance
Arvind
Could you please help with VBA or any other method to have multiple validation for one cel Cells A1:A100
User enters the Invoice numbers in these cells.
Data Validation:-
1. User should be able to enter only the words Starts with V,W & COM
if it starts with V or W then allow only 6 charectors
if its Start with COM then allow 8 charectors.
Thanks for your help in advance
Arvind