foundscan

  1. B

    Input Box is Not working

    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...
  2. B

    VBA is not Looping

    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...
  3. B

    VBA for Scanning Items Out/Into a registry

    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...
  4. B

    How to make a Macro "On/Off"

    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 =...
  5. B

    "Cancel" Button Doesn't Work on Dialogue Box

    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...
  6. B

    How to make a macro run its separate functions until told to stop

    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...
  7. B

    Find and Copy VBA Modification

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top