Simple Excel Macro
 

OK, OK...so (technically) I'm not a "new" user of Excel. I've created simple
macros in older versions of Excel, before macro and Visual Basic meant the
same thing.

I want to create a simple macro, but VB is foreign to me. All I want the
macro to do is press F2 (to edit the text in a cell), hit Home (to go to the
beginning of the cell contents) and insert a couple letters.

However, when I record it, the VB script replaces the text in my cell with
the text that was in the cell I used to record it.

Anyone know how to get Excel to do the simple macros it used to do?

Simple Excel Macro
 

Not Lotus. Maybe this simple?

Sub addtexttostartofcell()
ActiveCell = "aa" & ActiveCell
End Sub


--
Don Guillett
SalesAid Software

"TimWillDoIt" wrote in message
...
OK, OK...so (technically) I'm not a "new" user of Excel. I've created
simple
macros in older versions of Excel, before macro and Visual Basic meant
the
same thing.

I want to create a simple macro, but VB is foreign to me. All I want the
macro to do is press F2 (to edit the text in a cell), hit Home (to go to
the
beginning of the cell contents) and insert a couple letters.

However, when I record it, the VB script replaces the text in my cell with
the text that was in the cell I used to record it.

Anyone know how to get Excel to do the simple macros it used to do?

Simple Excel Macro
 

XL's recorder only records results of your actions, as you've found.

One way:

Public Sub InsertLetters()
ActiveCell.Value = "AB" & ActiveCell.Text
End Sub

In article ,
TimWillDoIt wrote:

OK, OK...so (technically) I'm not a "new" user of Excel. I've created simple
macros in older versions of Excel, before macro and Visual Basic meant the
same thing.

I want to create a simple macro, but VB is foreign to me. All I want the
macro to do is press F2 (to edit the text in a cell), hit Home (to go to the
beginning of the cell contents) and insert a couple letters.

However, when I record it, the VB script replaces the text in my cell with
the text that was in the cell I used to record it.

Anyone know how to get Excel to do the simple macros it used to do?

Simple Excel Macro
 

Yes...this is exactly what I need. I apologize for not being familiar with
VB scripts. I'm only just starting to scratch the surface of Actionscript in
Flash.

"JE McGimpsey" wrote:

XL's recorder only records results of your actions, as you've found.

One way:

Public Sub InsertLetters()
ActiveCell.Value = "AB" & ActiveCell.Text
End Sub

In article ,
TimWillDoIt wrote:

OK, OK...so (technically) I'm not a "new" user of Excel. I've created simple
macros in older versions of Excel, before macro and Visual Basic meant the
same thing.

I want to create a simple macro, but VB is foreign to me. All I want the
macro to do is press F2 (to edit the text in a cell), hit Home (to go to the
beginning of the cell contents) and insert a couple letters.

However, when I record it, the VB script replaces the text in my cell with
the text that was in the cell I used to record it.

Anyone know how to get Excel to do the simple macros it used to do?

Simple Excel Macro
 

Yes...this did what I needed it to do. I never wrote macros in Lotus, but it
might have been Word.

"Don Guillett" wrote:

Not Lotus. Maybe this simple?

Sub addtexttostartofcell()
ActiveCell = "aa" & ActiveCell
End Sub


--
Don Guillett
SalesAid Software

"TimWillDoIt" wrote in message
...
OK, OK...so (technically) I'm not a "new" user of Excel. I've created
simple
macros in older versions of Excel, before macro and Visual Basic meant
the
same thing.

I want to create a simple macro, but VB is foreign to me. All I want the
macro to do is press F2 (to edit the text in a cell), hit Home (to go to
the
beginning of the cell contents) and insert a couple letters.

However, when I record it, the VB script replaces the text in my cell with
the text that was in the cell I used to record it.

Anyone know how to get Excel to do the simple macros it used to do?

Simple Excel Macro
 

Glad to help

--
Don Guillett
SalesAid Software

"TimWillDoIt" wrote in message
...
Yes...this did what I needed it to do. I never wrote macros in Lotus, but
it
might have been Word.

"Don Guillett" wrote:

Not Lotus. Maybe this simple?

Sub addtexttostartofcell()
ActiveCell = "aa" & ActiveCell
End Sub


--
Don Guillett
SalesAid Software

"TimWillDoIt" wrote in message
...
OK, OK...so (technically) I'm not a "new" user of Excel. I've created
simple
macros in older versions of Excel, before macro and Visual Basic meant
the
same thing.

I want to create a simple macro, but VB is foreign to me. All I want
the
macro to do is press F2 (to edit the text in a cell), hit Home (to go
to
the
beginning of the cell contents) and insert a couple letters.

However, when I record it, the VB script replaces the text in my cell
with
the text that was in the cell I used to record it.

Anyone know how to get Excel to do the simple macros it used to do?