I am trying to create a recipe selector. I may be asking a lot, but hopefully, you folks can guide me.
I have an excel file with 800 different recipes. Each row contains the product name, product code, dimensions in respective columns. The excel file would be located in C:\Recipe.csv
I am trying to create a dropdown list using Activex Object: Combo Box 2.0, where the operator would select a product from the drop-down list which only has product names.
Once selected, it sends the information in different columns to plc tags.
I have never programmed in VBA so I have no clue on how to start or if this is the right way to do it.
I have an excel file with 800 different recipes. Each row contains the product name, product code, dimensions in respective columns. The excel file would be located in C:\Recipe.csv
I am trying to create a dropdown list using Activex Object: Combo Box 2.0, where the operator would select a product from the drop-down list which only has product names.
Once selected, it sends the information in different columns to plc tags.
I have never programmed in VBA so I have no clue on how to start or if this is the right way to do it.