Text notes when recording a MAcro

[Zac]

Is it possible to enter "Text Notes" when recording a MAcro.?

If so How?

Thanks,
ZAC

[Tom Schreiner]

Please give some more detail Zac...
I don't understand what you are trying to do?
You can do whatever you want while recording a macro.
Tom

[Ivan F Moala]

On 2002-04-23 04:36, Zac wrote:
Is it possible to enter "Text Notes" when recording a MAcro.?

If so How?

Thanks,
ZAC

Hi Zac
If you commenting your macro then @fter the
record button is clicke you are given the
option to enter comments in a discription box
By default it places the
"Macro recorded" [current date] "By" username
as defined in Tools > Options > general
User Name
If you don't mean this then please be a
little more explicit.

[Zac]

I've recorded a MACRO so that when a "user" enters a Filename in A1, it will SaveAs when they Push a Button.
The MAcro Reads as follows:

ThisFile = "S:AccountingSales" & Range("A1").Value
ActiveWorkbook.SaveAs Filename:=ThisFile

What I want to do (because I don't have access to S: Drive and I don't want to lose the intended path), is "Text" the S:\
path and enter a new path to use for modifying the macro. After I'm done I can delete the path I used, and re-activate the S: Path.

Hope that makes sense.

If I want to enter a line comment half way into a MACRO, How do I do it so it doesn't cause a Debug Error.

Thanks,
Zac

[Tom Schreiner]

Oh, I see...

Place Rem or an apostrophe before your note on each line...

Examples:

Rem this is a note and it will surely go to
Rem the next line...

Or:

' this is a note and it will surely go to
' the next line...

Hope this helps you.
Tom