Scan Barcode to designated cell columns and timestamp In/Out with Macro

bealret

New Member
Joined
Dec 10, 2018
Messages
2
Hi
Introducing myself, my skill in Microsoft excel is very basic. So my coding skill is minimum.
I am creating a simple system to track collection Tin time In and Out.

Below are the concept.

The tin number is fixed and is converted into barcode. When I press on the Time Out button, and scan a barcode (exp column F5) it will timestamp on column G5, If press on Time In button timestamp on colum H5, Press on Send Up button timestamp on column I5.

The last button (Amount). When the amount button is pressed and a tin barcode is scanned (column F5), it will prompt a message box requesting for amount of numbers. After pressing OK the amount of numbers will be transferred to column J5.

For additional, is it possible to lock each cell when there is data in the cell? My ideal, if column G5/H5/I5/J5 have data in it and the tin barcode is scan again, it will remain the first time data or it will prompt an error message. Is it possible to do it?

After explaining, the so call simple system, I felt is very complicated.
Is there any kind soul able to teach me or know any youtube link or tutorial link to share?

Below image is asample of my concept.

https://postimg.cc/K1dSvPtD
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

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