Fellow Programmers!

I am having a hard time figuring out how to get the following formula
to work inside of a macro...I have created a userform with a EXCEL
SPREADSHEET INSIDE OF A USER FORM (AS IT IS AVAILABLE AS A VBA PLUG-IN
[ADDITIONAL TOOLS] VERSION 12. The problem is the fact that the code
works fine if it used three times but if its used anymore after three
times it causes an error message stating the following...

===============================
Run-Time Error '-536608719 (e0040031)':

The formula you typed contains an error.

For information about fixing common formula problems, see Help.

If you are not trying to enter a foormula, avoid using an equals sign
(=) or minus sign (-), or precede it with a single quotation mark (')
===============================

CODE
--------

CALC.ActiveCell.Value = "=" & ActiveCell.Value & "&Z5000"

How it appears on the spreadsheet
--------------------------------------------------
=12345.

ActiveCell.Value = 12345
Z5000 = . (PERIOD)

The PERIOD is neccessary as it is making the number have .00 but I
wouldn't see why it would be crashing the program as it works fine in
the NORMAL style Excel Spreadsheet...

Any help is greatly appreciated!!!

Are you actually trying to enter ...
12345.12345.12345.12345. ????

If you are just trying to format a number then the "Format" function
provides a bewildering array of options to format data and numbers.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


wrote in message ups.com...
Fellow Programmers!
I am having a hard time figuring out how to get the following formula
to work inside of a macro...I have created a userform with a EXCEL
SPREADSHEET INSIDE OF A USER FORM (AS IT IS AVAILABLE AS A VBA PLUG-IN
[ADDITIONAL TOOLS] VERSION 12. The problem is the fact that the code
works fine if it used three times but if its used anymore after three
times it causes an error message stating the following...
===============================
Run-Time Error '-536608719 (e0040031)':
The formula you typed contains an error.
For information about fixing common formula problems, see Help.
If you are not trying to enter a foormula, avoid using an equals sign
(=) or minus sign (-), or precede it with a single quotation mark (')
===============================
CODE
--------
CALC.ActiveCell.Value = "=" & ActiveCell.Value & "&Z5000"

How it appears on the spreadsheet
--------------------------------------------------
=12345.
ActiveCell.Value = 12345
Z5000 = . (PERIOD)
The PERIOD is neccessary as it is making the number have .00 but I
wouldn't see why it would be crashing the program as it works fine in
the NORMAL style Excel Spreadsheet...
Any help is greatly appreciated!!!