Combination Combo Boxes - with a Twist

[Gil-Dale]

Hi Guys,

I am just starting to touch VBA / Excel / Macro's again after a couple year absence.

I am working on a reporting project (which I am sure is going to lead to numerous questions on here), however the first one I want to work out is the following.

I have a workbook - it has a series of worksheets based around monthly reports. (e.g. Jan-09, Feb-09, Mar-09)

I want to create a Combo Box that shows the list of Worksheets
Then based upon the Worksheet selected the 2nd combo box shows the values in cells b2:b37 (and in an ideal world removes any 'blank/null' results)

To populate some of the other drop downs in the forms I have created a Worksheet called Global (if that makes things easier for solutions).

So is this possible? And how would I go about doing it?

[rylo]

Hi

Where are the comboboxes? Directly on the spreadsheet, or on the forms? If on the forms, then how do you raise the form?

rylo

[Gil-Dale]

On the form - the 'featured' data will vary from month to month
(its basically a dashboard)

My vision (I have only really started working on this today) - is that one person will be editing the content via the forms - he can then generate the dashboard - and then export that out to PDF (well.... print to PDF)

[royUK]

have a look at the attached example

[Gil-Dale]

I must be really out of it - I think I have applied everything correctly - however I can't get the user form to show the drop downs.

Here is the excel file I am building it out of - I have another one i am trying out bits of code atm - really haven't done too much yet