inserting tick marks/hash marks

**psuexv** · 09-25-2007, 02:35 PM

Is there a way that I can format my cell to show tick marks when I type a number into the cell. When I type in a 4 it displays llll and so on.

**VBA Noob** · 09-25-2007, 02:53 PM

Would this event macro help. Enter a number in the range A1:A30

VBA Noob

**psuexv** · 09-25-2007, 03:28 PM

Thanks. That worked well. Though - is there a way to have a strikethrough so to speak when a multiple of 5 is entered. My main reasoning would be to be able to count the tick marks easily if say the number 100 was entered.

**VBA Noob** · 09-25-2007, 03:33 PM

Why would you want to sit down and count 100 ticks. Surely displaying the number is better in that case

VBA Noob

**psuexv** · 09-25-2007, 03:44 PM

Well I would definitely agree with that but it is very hard for some people to accept change. Our current method of doing our tallies is writing a tick mark on a form everytime we have a contact. I obviously want it electronically but was trying to keep it in the same tick mark format to not raise to much chaos.

**VBA Noob** · 09-25-2007, 03:57 PM

If they type 100 it will give you a 100 tick marks so no need to count or group.

May I suggest you type 100 in Col A and the visible ticks appear in Col B. Mix of old and new

VBA Noob