How do I get tick marks in Excel for auditing?

[rickdela1]

Hello all,

At some point or another , I somehow managed to download/install/set up a tick mark system I found on the web from someone named Mark Lehman. This system is tied to your personal.xls file and works with macros and .bmp files that have been created to symbolize the tick marks I am looking for.

The problem now is, I have no idea how I did this and I would like to have some of my colleagues utilize the same system but don't want them to go crazy with me trying to show them how to do it when I don't even fully know myself what I did.

Can anyone offer any solutions or know of any other place I can have me and my colleagues go out and find some tick marks and/or tick mark add-ins for Excel?

Thanks,
Rick

 

[lenze]

Hi and welcome to the board!!

Maybe my VBAExpress article CheckBox Alternative will be of some use??

lenze

 

[rickdela1]

Lenze,

Thanks for your reply, but when I click on your link, nothing happens. I get a "query failed" message. Any thoughts?

Thanks,
Rick

 

[jc.021286]

In all excels
http://office.microsoft.com/en-ca/project/HA011166011033.aspx

hold alt + 251 (on the key pad)

In Excel 2007, go through the excel options and enable your developer ribbon, google search if you do not know how.

In there, there is an insert, 3rd button under insert from the developer's ribbon will be a checkbox that you can manually check.

 

[bolandd]

Go to vbaexpress.com and search for checkbox alternative. The article is about the third or fourth one down...

 

[jasonb75]

Until Lenze gets back with the link, the manual method is to change the cell font to Marlett (symbolic font) then enter a or b into the cell, must be lower case.

There is no real difference between the 2, using b positions the character slightly higher in the cell but that's all.

 

[lenze]

Try this link!!
http://www.vbaexpress.com/kb/getarticle.php?kb_id=879

lenze

 

[rickdela1]

Thank you everyone for responding, however, I think I may have been unclear as to what I am looking for.

I am looking for tick marks, not check marks, to audit account schedules and other accounting documents on screen or in electronic format versus having to print them out and handwrite on them. I am looking for symbols that I can use to tie a balance to the GL, foot and cross-foot something, tie a number back to a source document, etc.

Any thoughts anyone? Thanks again.

Rick

 

[Taul]

Mark Lehman explains how to do it here
http://www.journalofaccountancy.com/Issues/2001/Jan/MakeYourMarkInSpreadsheets.htm

scroll down, about half way down the sheet.

EDIT
you can download them here
http://www.cbi.msstate.edu/cobi/sac/tickmarks.html