Modify code

[swalsh19]

Could someone show me how to create a macro that would insert a word phrase each key entry and then reset the focus to the next cell below.

I created one but it moves the focus to the cell below where I created the macro.

I would like 3 Macros that would add the following wording into the Particulars column...

CTRL + l = Charge For Lesson
CTRL + b = Charge For Books
CTRL + p = Payment

If you could either show me how to do this or insert it into the excel file attached I would appreciate it.

Steve

[protonLeah]

Right click the sheet tab and choose "view code".
In the VBasic Editor, double click "module2" in the project pane.
Replace the second line of your macro, i.e.,:

Range("J8").Select

with the following:

Please Login or Register  to view this content.

It will select the cell immediately below the one where the text was inserted.

[royUK]

I think you want to run the macro to enter one of these options into the active cell. You don't need a macro to do this, imply create a Data Validation list in the cells of he appropriate column. See this for guidance

http://www.excel-it.com/data_validation.htm