Excel sheet hanging on search

Closed - This job posting has been filled and work has been completed.

Job Description

I have an inventory excel sheet. I used a template for a library check-in check-out system.
I use it in the shop for employees to check-in or out their tools.

everything works. although when I click the 'check-out' button excel hangs for like a minute. when I click 'check-in' it is instant.

the excel sheet is not that big. and when complete would have 1200 lines of tools added.

I am not sure if this 'hanging' issue is just the nature of excel. I have tried it on several different machines.

Skills: visual-basic