scanstring

Hi, all - I'm having difficulty with the second InputBox in my code. Ideally when asked for the "Employee ID Number," the user would scan a barcode to populate a corresponding cell in Column C; however, although I can get the scanner to read and recognize the barcode on the ID cards, the ID...

Hi, all - I'm trying to develop a macro for asset traceability. Right now, I'm able to scan the asset (iPad) based on a QR code, and timestamp when it leaves our office - the macro loops until the user stops it, minimizing the need for the use of the mouse or keyboard. I'm trying to add a...

Hi, all! I'm working on a program that would track iPads used by our employees. Ideally, the system would allow me to press a button to activate a search VBA, scan a bar code on the iPad and once the scanstring is located (in column A), allow me to scan an employee's ID card to populate the...

Hi, all - Would it be possible to turn to below code into a Macro that repeats its core function until told to stop? Sub Item_Return() Dim scanstring As String Dim foundscan As Range Dim ws As Worksheet Dim foundscan_address As String Set ws = ActiveSheet scanstring =...

Hi, All! Whenever I hit press the "Cancel" button on the dialogue box, the worksheet still seems to run the function while searching for nothing. I'm not sure if it's an issue with the working in VBA, or an issue with the dialogue box, but I haven't been able to find a solution. Below is the...

Hello again, all! Is there a way to modify the below code so that instead of have to push the button for every entry, I could simply activate the "Item Return" macro, scan in multiple entries, and then "turn-off" the macro - so to speak. Sub Item_Return() Dim scanstring As String...

Hi, all! I'm working on a small inventory tracking system, and have run into a bug that I can't find a solution to. The "Item Return" function (button activated VBA macro) searches the active worksheet for a string and, once found, copies the string from Column D to Column H. The bug that I...