If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
To Ian Thanks!
Yeah! and thanks Ian,
I made my chord builder spreadsheet work-- so far. You can see the results at http://www.ssor.net/Sheet/songbuilder.xls now I just have to figure out how to add # to a key. I could have created a separate button for sharp for each chord, but that would have been too many text boxes. What I want is this: When I select the cell that has the chord already in it, say A I want the cursor to move one character to the right within the cell and then insert # -- so if it was A it would become A# if Am it would become A#m. Doable? Ross |
#2
|
|||
|
|||
Ross,
Is this what you are after? http://cjoint.com/?jzb7KH7Ufd -- HTH Bob Phillips "Ross" wrote in message ... Yeah! and thanks Ian, I made my chord builder spreadsheet work-- so far. You can see the results at http://www.ssor.net/Sheet/songbuilder.xls now I just have to figure out how to add # to a key. I could have created a separate button for sharp for each chord, but that would have been too many text boxes. What I want is this: When I select the cell that has the chord already in it, say A I want the cursor to move one character to the right within the cell and then insert # -- so if it was A it would become A# if Am it would become A#m. Doable? Ross |
#3
|
|||
|
|||
Almost!,
But fori instance in testing it I put my cursor over a line and caused G9 (G ninth) by the macro. Then I clicked the # textbox and the result was G9# what I need is for it to be G#9 (G sharp ninth) The # must be placed as the second carecter in the selected cell. But thanks again, we are getting there! Ross "Bob Phillips" wrote in message ... Ross, Is this what you are after? http://cjoint.com/?jzb7KH7Ufd -- HTH Bob Phillips "Ross" wrote in message ... Yeah! and thanks Ian, I made my chord builder spreadsheet work-- so far. You can see the results at http://www.ssor.net/Sheet/songbuilder.xls now I just have to figure out how to add # to a key. I could have created a separate button for sharp for each chord, but that would have been too many text boxes. What I want is this: When I select the cell that has the chord already in it, say A I want the cursor to move one character to the right within the cell and then insert # -- so if it was A it would become A# if Am it would become A#m. Doable? Ross |
#4
|
|||
|
|||
Also, I guess that is in HTML so how do I see what the macro is?
"Bob Phillips" wrote in message ... Ross, Is this what you are after? http://cjoint.com/?jzb7KH7Ufd -- HTH Bob Phillips "Ross" wrote in message ... Yeah! and thanks Ian, I made my chord builder spreadsheet work-- so far. You can see the results at http://www.ssor.net/Sheet/songbuilder.xls now I just have to figure out how to add # to a key. I could have created a separate button for sharp for each chord, but that would have been too many text boxes. What I want is this: When I select the cell that has the chord already in it, say A I want the cursor to move one character to the right within the cell and then insert # -- so if it was A it would become A# if Am it would become A#m. Doable? Ross |
#5
|
|||
|
|||
Hi Ross,
I waste most of my time trying to play guitar and trying to use excel so I found your post interesting. If you haven't yet solved the problem with sharps the following worked for me: Sub Sharp() If ActiveCell.Value "" Then Dim Chord As String Chord = ActiveCell.Value With ActiveCell .Value = Left(Chord, 1) & "#" & Right(Chord, Len(Chord) - 1) .EntireColumn.AutoFit End With End If End Sub I added the autofit line to improve the chord's visibility. I hope this is useful. Ken Johnson |
#6
|
|||
|
|||
Thanks Ken,
It works perfectly. Ross PS Any ideas of how to traspose keys with a macro? "Ken Johnson" wrote in message oups.com... Hi Ross, I waste most of my time trying to play guitar and trying to use excel so I found your post interesting. If you haven't yet solved the problem with sharps the following worked for me: Sub Sharp() If ActiveCell.Value "" Then Dim Chord As String Chord = ActiveCell.Value With ActiveCell .Value = Left(Chord, 1) & "#" & Right(Chord, Len(Chord) - 1) .EntireColumn.AutoFit End With End If End Sub I added the autofit line to improve the chord's visibility. I hope this is useful. Ken Johnson |
#7
|
|||
|
|||
Ross,
I've never done it but I'm sure it could be done since transposing is just applying rules to the chord pattern. You've got me thinking now, trouble is fast thinking's not my forte. Do you plan on somehow using the table you have on the worksheet? That's a key transposition table I think. |
Thread Tools | |
Display Modes | |
|
|