In VBA I want to create a UserForm that displays a prepopulated list (Sheet2 Column B) in a Dropdown but also displays an "add" choice at the bottom of the list. If the Add choice is selected it will make a new field appear below the Dropdown, or maybe ungray one. The user can then fill in the...
I am working on a excel project that contains two sheets: Sheet1 and Sheet2. Each sheet has a series of checkboxes that have identical titles.
EXAMPLE:
Sheet1
box1
box2
box3
Sheet2
box1
box2
box3
REAL WORLD APPLICATION: Sheet1 is checkbox data that is collected over the phone and may not...
I would like to be able to choose certain criteria from a drop down list(audience and room size) and have a good portion of the worksheet prepopulate based on that choice. In this case, it would be audio equipment that goes along with each room size. Right now we have each budget size in a...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.