I should explain what I am looking for a bit better.

I have a message box that pops up when a button is pushed. The operator chooses "YES" or "NO." When "YES" is clicked, I need a user form to open that has the following stuff in it: (the [ ] represents a check box in the user form.)

[ ] The stated uncertainty of the measured values has not been taken into account for the pass / fail indicators.

[ ] *An asterisk in the scope column indicates that those test results are not covered by our current A2LA accreditation.

[ ] This Certificate of Inspection includes additional pages of inspection results supplied electronically to the customer.

[ ] This Certificate of Inspection was completed using a customer report template.

[ ] Temp [text box activates if TEMP is checked]

[ ] Humidity [text box activates if HUMIDITY is checked]

[ ] Additional Notes: [large text box activates if ADDITIONAL NOTES: is checked]


As these boxes are checked i need them to be added to specific cells in my workbook so they can be added to the comments pages of my report and condensed so that there is no space between them if some of the middle check boxes or left blank.

I can make the user form in the VBA editor but have no idea how to get the check boxes to interact with the workbook. I also don;t know how to get the userform to pop up when the user clicks "YES" on the message window.

Please let me know if you have any suggestions or questions. Thanks in advance!