I have a drop down box labeled environmental that a user chooses "yes" or "no".
Yes copies the data from the sheet labeled environmental to a sheet labeled finished sheet.
Later a command button saves the data from the finished sheet label to a .txt file on the user's desktop.
I need to put somewhere on my userform a check box or buttons for a user to choose what type of environmentals they want turned on. If the button or check box is clicked it turns a cell to on, but this is only if the user chooses envrionmentals.
Is it possible after the users chooses yes from the drop down box a pop up with check boxes appears and allows the user to click which ones get turned on.
Or is there an easier way to do this.
I would be happy to share the program with anyone intersted in taking a look. This is above my knowledge in visual basic. any help is greatly appreciated