New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

drop down box that creates a pop box for check boxes

Macros, VBA, Excel Automation, etc.

drop down box that creates a pop box for check boxes

Postby laurensims41 » Wed Sep 07, 2016 4:07 pm

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
  • 0

laurensims41
Rookie
 
Posts: 15
Joined: Feb 3, 2016
Reputation: 0
Excel Version: Office Professional Plust 2010

drop down box that creates a pop box for check boxes

Postby Embobebof » Sun Dec 11, 2016 12:29 am

Hi Luke

Sorry to ask but did you have a chance to have a look at that code?

Paul
  • 0

Embobebof
Rookie
 
Posts: 3
Joined: Nov 3, 2016
Reputation: 0
Excel Version: 2007


Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 53 guests