Premium Excel Course Now Available!

Build Professional - Unbreakable - Forms in Excel

45 Tutorials - 5+ Hours - Downloadable Excel Files

Instant Access! - Lifetime Access!
View Course

drop down box that creates a pop box for check boxes

Macros, VBA, Excel Automation, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

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 2 guests