On the Excel Ribbon, Click on the Data Tab. Select Data Validation. Select Data Validation again.
In the allow box, select text length
In the data box, select less than
In the maximum box, select 9
Click ok.
On the Excel Ribbon, Click on the Data Tab. Select Data Validation. Select Data Validation again.
In the allow box, select text length
In the data box, select less than
In the maximum box, select 9
Click ok.
Alan
Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
Like my answer? Click * below
Database Normalization
Database Principles
Pivot Table Tips
Excel Video Tutorials
SumProduct Video Tutorial
DataPig Access Tutorials
MS Query Tutorial
SQL Tutorial
Posting Permissions
Reply With Quote
Bookmarks