Thanks Ian,
That will be useful. Now what I want to happen for the second part of my
question is this: I want to invoke my chord placement macros (as explained
in second part of first post) so that when I click on the textbox I have a
assigned the macro to it will paste the chord, E or F or F# in the currently
selected cell. I will create a series of small text boxes, each with the
text for the chord A, Am, A7, etc and assign a different macro for each one.
What I want to happen is, I click on a particular cell and when I click the
textbox with chord I want in the selected cell, it is pasted (or typed) into
that cell. Since I will also have a transpostion chart that I have created
on the sheet, using this method, I will easily be able to transpose the
chords of any song I want. I then want to have one more text box that has #
in it and the way the macro would work assigned to that one is that say the
chord I need is A#m I would invoke the Am macro, double-click that cell so
that my cursor is between the A and the m and then click on the # text box
to insert the sharp. That way, I don't have to have a separate text box for
A,A#, Bm,B#m . . .
To make this clearer, I have uploaded the file "Song builder" with an
example song pasted in. Please have a look at it.
It is at: http://www.ssor.net/Sheet/songbuilder.xls

Thanks in advance for your help

wrote in message ...
Right click on sheet tab, select View Code and paste this code at the
flashing cursor.

As written the macro will move the cursor down one cell form the current
position.

Sub OffsetSelectedCell()
'Replace r & c below as required
r = 1 ' 0 = stay put, 1 = down 1, -1 = up 1
c = 0 ' 0 = stay put, 1 = right 1, -1 = left 1
ActiveCell.Offset(rowOffset:=r, columnOffset:=c).Activate
End Sub


--
Ian
--
"Ross" wrote in message
...
Hi,
I don't know how to write macros, I only create them by recording them.
I would like to know how I tell the cursor to move cells to right, left,
or up and down, from a cell, so that when I run the macro, the movent
will happen from the current selected cell.

Also, I am trying to create a spreadsheet that I can paste lyrcs to a
song into, and then having a series of text box buttons I create -- each
with the name of a chord, like Am or b7 as the text in it. Each one of
these would be assigned a macro. I want to be able to click above a cell
above the particular line of lyric, and then go and click on the text box
associated with the chord I want and have that cord pop into selected
cell. I would format all the columns as one cell wide. I did this and
when I paste in the lyracs, say starting at A1, the lyrcis are displayed
across the page, even though they are all in the first cells. of column
A. (I doulbe space the lyrics before I paste them in, leaving a row of
single spaced cells above each line, in which to put my chords) Is that
doable?