Break long lines of code, Map enter key with OnKey

**capngene** · 02-02-2012, 05:43 PM

I get the error message "illegal character" when I use the underscore character to break a long line of code into two or more shorter lines.

My full macro was originally written with Excel 2003. The underscore character works in that portion of the code. I'm adding some lines to the macro with Excel 2011. I get the error message in the new portion. How do I break lines in Excel VBA 2011? I use the file type ".xlsm" to save and run macros in Excel 2011. It uses the same Personal Macro Workbook and most of my other macros work. They do not recognize the equivalent keys, for example, CMD-OPT-b

I tried to use ONKEY to call with the FUNCTION key, but it doesn't work:

Please Login or Register  to view this content.

This worked until I saved, quit, and restarted.

**OnErrorGoto0** · 02-02-2012, 06:16 PM

The underscore is still the line continuation character in 2011. What was the line of code you tried to break (and where did you put the underscore)?

**capngene** · 02-02-2012, 06:46 PM

ActiveChart.Shapes.AddTextbox(msoTextOrientationHorizontal, 467, 9, 180, 140).TextFrame.Characters.Text = "WIRELESS ENGINEEERING CORP. ORLANDO, FL 32819 Date Job#: P/N: S/N: Pattern: Cut: Polarization: Gain: Engr: EPA "

I added yhe underscore between Characters and .Text:
Characters. _ Text

**OnErrorGoto0** · 02-02-2012, 06:49 PM

Where did you put the underscore? Within the string value perchance?

**capngene** · 02-02-2012, 06:55 PM

I put it in the same relative position as it is in some of my old macros, after a "." and before the next operation with spaces around it, also without the spaces.

Characters. _ Text

**OnErrorGoto0** · 02-03-2012, 09:52 AM

That works fine for me (I am assuming you actually pressed return between the underscore and the word Text - you would get an invalid character error if they are on the same line)

**capngene** · 02-04-2012, 08:22 AM

I had it on the same line, Thanks for the tip to put the return in the line. (Now I feel stupid!)

Thanks for the help.

Any suggestions for the OnKey problem?