vba in excel
2 TopicsOption button to change an inserted PDF?
Is there a way I can use an option button to change an inserted PDF? Like it's the same layout just has different information on it, I don't want to make 4 different excels for each one. If I have to, oh well. Like if this radio button is selected then show this PDF. Just don't know how I would code that.533Views0likes0CommentsComplex VBA Excel - Best Practice (KISS)- Visual Diagrams-Wireframes or Recommendations
Frustrated quickly when getting 40 lines of VBA down to learn it can be written In 2 lines going a different route. Recommendations for the best practices on CLEANIEST way possible for Excel VBA objects, properties, and methods being applied. Simple right. Excel allows the nesting >64 levels within a function, everything become complex at a point :) MUST use Excel VBA per requirement. Trying to locate the simplest "diagram/mapping/structure" reference guide to assist with 'order of operation' when it comes to using VBA within Excel data types are stored procedures, Access tables, and Excel worksheets/books! Example: - Workbook with 15 worksheets (SOME cells/columns/rows of data are being used in a variety of functions) from them all - Different arrays, formatting, tables, charts, functions, starting points, on each worksheet in workbook - Additional workbook with some additional data, functions, calculations to be leveraged - Create Report/Result Worksheet file in location 'X' - Title Report/Result Worksheet '______' - Protect Report/Result Worksheet from being broken by end user that NEEDS the excel version! - 5000+ lines of VBA code Excel is powerful trying to keep it SIMPLE, ORDERLY is the goal! Visual - Mappings of Best Practice - Order of Applying all the check, applying references correctly, looping as to not cause performance hit when loading1.8KViews0likes2Comments