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

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

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

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

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

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

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.