A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

To Ian Thanks!



 
 
Thread Tools Display Modes
  #1  
Old September 24th, 2005, 10:01 PM
Ross
external usenet poster
 
Posts: n/a
Default 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  
Old September 25th, 2005, 12:47 AM
Bob Phillips
external usenet poster
 
Posts: n/a
Default

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  
Old September 25th, 2005, 01:00 AM
Ross
external usenet poster
 
Posts: n/a
Default

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  
Old September 25th, 2005, 01:03 AM
Ross
external usenet poster
 
Posts: n/a
Default

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  
Old September 25th, 2005, 03:55 AM
Ken Johnson
external usenet poster
 
Posts: n/a
Default

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  
Old September 25th, 2005, 04:19 AM
Ross
external usenet poster
 
Posts: n/a
Default

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  
Old September 25th, 2005, 04:34 AM
Ken Johnson
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.