restricting the number of characters in any cell ?
Posted by denis on October 25, 2001 2:05 PM
Is there any way of only allowing one character in any cell and also once a character has being typed in a cell, the cell to the right becomes active.
any idea's appreciated
Thanks
Posted by Qroozn on October 25, 2001 3:41 PM
validation
you can put data validation in the cell so that the source is "a,b,c,d,e,f,g,h,I,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z". and a VBA macro will enable it to to jump to the next cell. but i am not the quickest at that.
Posted by Alex James on October 25, 2001 5:40 PM
To restrict to 1 character, go to Data>Validation and in the Allow box select Custom. In the Formula box enter : =LEN(A1)<2<p>To select the cell to the right after an entry is made, go to Tools>Options>Edit>MoveSelectionAfterEnter>Direction>Right.
