This is a continuation of http://www.mrexcel.com/board2/viewtopic.php?t=180855
The original concept has been changed due to the suggestion of a Board Member. I no longer need to key off of Conditional Formatting, instead, as you can see, the code focuses on the condition of the cells.
I need to know: How do I populate the variable DwgList with the list of changed drawings and pass that list to a UserForm. Is it possible to populate a variable number of UserForm Option Buttons with a variable? For example, if three Drawings have changed, create three Option Buttons, each with the Drawing #. Along the lines of: "These are the drawings that have changed, which one do you want to see?"
What I have: the list of changed Drawing #'s; a way to open the PDF files associated with the Drawing #'s. I need a strategy to pass those Drawing #'s to a UserForm for the User to choose for viewing.
As a side, how do I check to see what the variable DwgList is populated with?
Thanks for your time.
Dave
The original concept has been changed due to the suggestion of a Board Member. I no longer need to key off of Conditional Formatting, instead, as you can see, the code focuses on the condition of the cells.
I need to know: How do I populate the variable DwgList with the list of changed drawings and pass that list to a UserForm. Is it possible to populate a variable number of UserForm Option Buttons with a variable? For example, if three Drawings have changed, create three Option Buttons, each with the Drawing #. Along the lines of: "These are the drawings that have changed, which one do you want to see?"
What I have: the list of changed Drawing #'s; a way to open the PDF files associated with the Drawing #'s. I need a strategy to pass those Drawing #'s to a UserForm for the User to choose for viewing.
As a side, how do I check to see what the variable DwgList is populated with?
Thanks for your time.
Dave