Help with VBA to create a guitar scale generator

[Tgv10]

Hello.

Can anyone help me create an excel file to generate guitar scales. I've been looking on the internet for a file and found this one:

Dicionario_de_Escalas_e_Arpejos_Rev0.1.xlsb

drive.google.com

This is almost what I want but I would like to understand to make my own file with some adjustments. Does anyone know what I should look for? How do you use multiple buttons to trigger different macros? Are they comboboxes, userforms or what are they?.

Thanks.

 

[Micron]

Each button would have its own click event thus running its own code. One combo can take the place of many buttons by virtue of the chosen list item and is usually a better option than many command buttons or option buttons. I didn't download the file for those questions as I don't need a scale workbook file to provide that advice. At first I started to answer based on this being about fret scales so didn't see why such a thing would be of value, but then I figured it's about e.g. pentatonic type scales.

 

[Tgv10]

Each button would have its own click event thus running its own code. One combo can take the place of many buttons by virtue of the chosen list item and is usually a better option than many command buttons or option buttons. I didn't download the file for those questions as I don't need a scale workbook file to provide that advice. At first I started to answer based on this being about fret scales so didn't see why such a thing would be of value, but then I figured it's about e.g. pentatonic type scales.

Do you have any suggestion for what should I search?

 

[Micron]

Not really. "How to create userforms in Excel" ?

 

[Tgv10]

Not really. "How to create userforms in Excel" ?

No. How to make a combobox in active x and assign a macro to each element in the combobox list. I know how to make the combobox and add elements to the combobox but I can't assign a macro to each element of the combobox.

 

[Micron]

You can't - directly. But you can direct code execution by using one event (e.g. AfterUpdate event) and direct flow based on the selected list item. One way is a bunch of nested IF blocks, or an If...Then...Else type of decision. If there are a lot of list items, a Select Case block is often more efficient - at least in terms of writing code.
e.g.

Select Case Me.myTextbox
  Case "dog"
      'do dog stuff
  Case "cat"
     'do cat stuff
  Case "bird"
    'do bird stuff
  Case etc
     'and so on
  Case Else 'handles all else
      'do else stuff
End Select