Assembly Barcode for Inventory, how to get multiple part numbers from 1 assembly number

Really, you're using the wrong tool. Excel is a calculator, what you're trying to create is a database - that's what Access is for. Do you know how to use Access?

Kyle,

Thanks for the tip, I will have to look into Access.

At this point, I'm so close to getting what I need from Excel, I'm going to try to shoehorn it to fit.

I was able to find VBA code that does what I need (searches for and splits comma delimited text), except I'd like it to run every time I scan an item. Currently, it only works when I manually run the code.

Here's the code:

Please Login or Register  to view this content.

All credit to trincot at stack overflow: "how-to-split-cells-containing-multiple-values-comma-delimited-into-separate-ro"

My apologies if this is in the wrong section now, and thanks in advance for any feedback!

I was able to get what I needed from the code above by adding the following after the loop:

Please Login or Register  to view this content.

Then on my Remove/Add to Stock sheets, I setup a Worksheet - SelectionChange code to Call Splt()

My assembly QR codes are just a comma delimited list, and the "Range . . ." code after the loop is a simple (probably inefficient) way to prevent anyone from editing previously entered data.

Any critiques are welcome, I'm sure there's a better way to do this.