Hello.
I need help choosing the type of VBA code to use to create a musical scale generator in Excel. I want to define the musical notes and the intervals between the notes and I want Excel to automatically generate the notes using the first note and the intervals of that scale. For example I want to define these rules:1-T=C (C, C#, D, D#, E ...)2-musical intervals (T, 2m, 2M, 3m, 3M...), and the 3-intervals of the "Major" scale ( T, 2M, 3M)I ask for the C Major scale and the result will be (C, D, E)Basically I want to define the cases in relation to the intervals between the notes and this way I don't need to create 12 cases but only 1. What's the best way to do this? Should I go through the "arrays"? Thanks.
I need help choosing the type of VBA code to use to create a musical scale generator in Excel. I want to define the musical notes and the intervals between the notes and I want Excel to automatically generate the notes using the first note and the intervals of that scale. For example I want to define these rules:1-T=C (C, C#, D, D#, E ...)2-musical intervals (T, 2m, 2M, 3m, 3M...), and the 3-intervals of the "Major" scale ( T, 2M, 3M)I ask for the C Major scale and the result will be (C, D, E)Basically I want to define the cases in relation to the intervals between the notes and this way I don't need to create 12 cases but only 1. What's the best way to do this? Should I go through the "arrays"? Thanks.