Prev Previous Post   Next Post Next
  #1   Report Post  
Ross
 
Posts: n/a
Default movement

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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I control cell movement with the Tab key? Bojo Excel Discussion (Misc queries) 4 September 3rd 05 01:16 AM
Force Cell Movement Jasmine Excel Discussion (Misc queries) 1 March 19th 05 12:06 AM
How do I get a hyperlink to track data movement? Kev Nurse Excel Discussion (Misc queries) 1 February 2nd 05 10:59 PM
How do I get a hyperlink to track data movement? Kev Nurse Excel Discussion (Misc queries) 0 February 1st 05 07:59 PM
How do I create automatic cell movement when using excel babykates Excel Worksheet Functions 1 November 1st 04 01:22 PM


All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"