Help editing a macro from Excel 2007 for Excel 2011 for Mac

[MYSLibrarian]

Hello all!
I found a macro on these boards for tracking attendance with a barcode scanner, but the code does not seem to function in Excel for Mac 2011. Here is a link the the old thread with the macro I'd like to use:

Need Help with an Attendance Sheet Using a Barcode Scanner - Page 2

I didn't want to necro a thread that old so I made a new post. This functionality is exactly what I need. Any assistance is greatly appreciated!

 

[RoryA]

Welcome to the forum.

Please be more specific than "does not seem to function". What happens exactly? Do you get an error? If so, what error and on what line of code?