2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/J0ne5
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#Excel compatibility
#Excel alternatives
#rows.com
#cloud-based spreadsheet applications
#AI-driven spreadsheet solutions
#product configurator
#BOM
#quote
#VBA
#2D picture
#Excel
#drop down
#materials
#composite picture
#library
#screenshot