Worksheet event code

[Peter Muller]

Hello Excel Experts,

I run macro’s from a Drop Down list. I have 20 macro’s in the list.

• These macro’s run from a worksheet event code. Is it at all possible to group the macros into sub categories in the drop down list, similar to a dependent drop down list, within the worksheet event code? This then allows me to select the category, which opens another view window, from which I select the macro, and it then runs immediately?
• 
  
• Is it possible to increase the size of the view window when I click on the drop down arrow so that I do not have to scroll down and look for the macro I want to run?

Thank you

 

[Caleeco]

Hello Peter,

It sounds like you want to have create a dependent drop down list. Check out this guide which explains how to create it.

Dependent Drop-down Lists in Excel

This example describes how to create dependent drop-down lists in Excel. Here's what we are trying to achieve:

www.excel-easy.com

Cheers
Caleeco

 

[Peter Muller]

Hello Peter,

It sounds like you want to have create a dependent drop down list. Check out this guide which explains how to create it.

Dependent Drop-down Lists in Excel

This example describes how to create dependent drop-down lists in Excel. Here's what we are trying to achieve:

www.excel-easy.com

Cheers
Caleeco

Thank you for getting back to me, but this is not what I am looking for

 

[Yongle]

@Peter Muller - simply saying "this is not what I am looking for" is unlikely to help you get what you do want.
Without repeating what you have already said in post#1 ... perhaps you could explain in more detail exactly what you do want - it may help if you illustrate with sample data

 

[Peter Muller]

@Peter Muller - simply saying "this is not what I am looking for" is unlikely to help you get what you do want.
Without repeating what you have already said in post#1 ... perhaps you could explain in more detail exactly what you do want - it may help if you illustrate with sample data

Okay, thank you. Will do shortly

 

[Peter Muller]

Okay, thank you. Will do shortly

I have a spreadsheet with 7000+ rows, containing 4 divisions/groupings/categories named Quarter 1, Quarter 2, Quarter 3 and Quarter 4.

Quarter 1 starts at Row 3 to 1800, Quarter 2 from Row 180 to Row 3800, etc.

I extract information from each quarter via macro’s, five to six macro’s per section.

All the macro’s are contained in a Data Validation List, activated in Range 'A2'

When I click on Range ‘A2’, the data validation window opens, listing the 20 odd macro’s one below the other, which I then scroll through to activate the relevant Macro. When I select the macro I want, the macro is activated via the worksheet event code.

Instead of scrolling through the list showing 20+ macro’s, I would like to only see Quarter 1, 2, 3 and 4 shown when I select A2, and when I then select Quarter 1, it opens a second window listing the 5+ macro’s relevant to Quarter 1. When I then select the relevant macro, it automatically executes. All of this is contained/activated in/from Range A2.

 

[Norie]

Peter

Unfortunately you can really do what you want with data validation, in particular you can't make the data validations lists any bigger.

Even if you increase the font size of the cells containing the validation the dropdown will stay the same size.

Instead of data validation you could try using ActiveX comboboxes or a userform.

 

[Peter Muller]

T

Peter

Unfortunately you can really do what you want with data validation, in particular you can't make the data validations lists any bigger.

Even if you increase the font size of the cells containing the validation the dropdown will stay the same size.

Instead of data validation you could try using ActiveX comboboxes or a userform.

Thanks Norie, hopefully there is a solution to my other query.

 

[Norie]

Peter

What other query

Do you mean having dependent drop downs?

 

[Peter Muller]

Peter

What other query

Do you mean having dependent drop downs?

Yes, as explained in #6