Worksheet event code

Peter Muller

Board Regular
Joined
Oct 15, 2018
Messages
133
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Caleeco

Well-known Member
Joined
Jan 9, 2016
Messages
980
Office Version
  1. 2010
Platform
  1. Windows
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.


Cheers
Caleeco
 

Peter Muller

Board Regular
Joined
Oct 15, 2018
Messages
133
Office Version
  1. 365
Platform
  1. Windows
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.


Cheers
Caleeco

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

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,977
Office Version
  1. 365
Platform
  1. Windows
@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

Board Regular
Joined
Oct 15, 2018
Messages
133
Office Version
  1. 365
Platform
  1. Windows
@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

Board Regular
Joined
Oct 15, 2018
Messages
133
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Apr 28, 2004
Messages
76,357
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
Oct 15, 2018
Messages
133
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Apr 28, 2004
Messages
76,357
Office Version
  1. 365
Platform
  1. Windows
Peter

What other query

Do you mean having dependent drop downs?
 

Forum statistics

Threads
1,181,598
Messages
5,930,800
Members
436,761
Latest member
mintwaxed

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