Hello,
I'm trying to allow the user to scan a barcode (Code129) that triggers a filter in column G "Program". For example, FEM, RR, and FF are some of my programs. I will create a simple barcode. One for FEM, one for RR, and FF, and when the user scans that specific barcode, it filters out the parts associated with that program type in my "Component Bar Codes" worksheet. This will allow for faster access to parts in the list for the user to locate. Not the best at VBA when it comes to these kinds of code, so any help would be great. I've seen some examples on mrexcel but nothing concrete that worked for me. See my screenshot below.
I'm trying to allow the user to scan a barcode (Code129) that triggers a filter in column G "Program". For example, FEM, RR, and FF are some of my programs. I will create a simple barcode. One for FEM, one for RR, and FF, and when the user scans that specific barcode, it filters out the parts associated with that program type in my "Component Bar Codes" worksheet. This will allow for faster access to parts in the list for the user to locate. Not the best at VBA when it comes to these kinds of code, so any help would be great. I've seen some examples on mrexcel but nothing concrete that worked for me. See my screenshot below.
