Graphical display based on generated BOM
We have created a fairly complex Excel based product configurator. We have been using it successfully for about 9 months now, and as with all projects scope create is happening. Currently it is drop down driven to create a BOM of materials that is then used to generate a quote. Now we are wanting to implement a very basic generic 2d picture to go along with the quote. I'm thinking just a library of screen shots of the various BOM options that could be layered overtop each other to create a composite picture. A close example would be a tow strap that has the following variables that I would need account for. Size (1"-4"), Color, End Fitting (loop, hook, chain, etc), plus a couple more.
I'm assuming I would need to utilize VBA for this. However I have very limited experience with VBA thus far. I would appreciate if someone could point me in the right direction for to search for, or tutorial videos to watch. I haven't had much luck finding diy info, just companies wanting to offer their services to build the graphics for us.
[link] [comments]
Want to read more?
Check out the full article on the original site