New member w/ a question about Combo boxes/Macros/Filters

Bacchus815

New Member
Joined
Jul 30, 2007
Messages
5
Hello all. Before posting, I did a search, but couldn't (knowingly) find a thread describing my problem.

I'm working on a project where a user would:

1. Open Excel and have a sheet with three combo boxes (depending on how they wanted data displayed), with each assigned a macro.

2. Let's use the first one for example: By Facility & Nursing Unit

What I'm trying to do is, if the user selected "Facility A -- Nursing Unit 1" from the Combo box, have only that data (not for all 87 comobs I have) be displayed in another worksheet in the file and that sheen would open up for the user to print.

Right now, when I select something in my combo box, it will run the macro in the same worksheet behind the combo boxes, creating a quite interesting array of colors b/c of the formating/conditional formating I have in my macro.

I pushed for a simpler method of using just Auto Filtering, but alas...

Any help would be much appreciated. Feel free to ask any clarification questions!

Thanks so much!
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,181,418
Messages
5,929,796
Members
436,695
Latest member
yashpisat

We've detected that you are using an adblocker.

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.
Go back
Top