The TEXT function in Excel VBA 2000
 

When using the TEXT function I get the following message:

"Compile Error: Sub or Function not defined" It is
supposed to be a built in function such as Left$ or
Instr. It is in the help. If you can go to help, type in
functions and a list of all VBA functions come up click
on T then go to the TEXT function. I tried to duplicate
the example but still get the message about Sub or
Function not defined.

Call me if you care to

Tory
(714) 638-5714

The TEXT function in Excel VBA 2000
 

In The VB Editor, go to the Tools menu, select References. Look at the list.
Are there any marked as missing? If so, you need to either un-check them (if
you don't need them), or use the Browse button to find them.

If there are any libraries marked as "missing", your code won't compile.

On Mon, 27 Sep 2004 20:45:31 -0700, "Tory Zimmerman"
wrote:

When using the TEXT function I get the following message:

"Compile Error: Sub or Function not defined" It is
supposed to be a built in function such as Left$ or
Instr. It is in the help. If you can go to help, type in
functions and a list of all VBA functions come up click
on T then go to the TEXT function. I tried to duplicate
the example but still get the message about Sub or
Function not defined.

Call me if you care to

Tory
(714) 638-5714

The TEXT function in Excel VBA 2000
 

Tory,
"TEXT" is an Excel worksheet function. As such VBA does not know what it
means unless you use:
Excel.WorksheetFunctions.Text

Hope that helps

NickHK

"Tory Zimmerman" wrote in message
...
When using the TEXT function I get the following message:

"Compile Error: Sub or Function not defined" It is
supposed to be a built in function such as Left$ or
Instr. It is in the help. If you can go to help, type in
functions and a list of all VBA functions come up click
on T then go to the TEXT function. I tried to duplicate
the example but still get the message about Sub or
Function not defined.

Call me if you care to

Tory
(714) 638-5714

The TEXT function in Excel VBA 2000
 

msgbox application.text(123.53,"0.00%")
worked ok.

but depending on what you're doing, maybe VBA's Format is what you want:
msgbox format(123.53,"0.00%")

(there are a few formats that aren't shared between these similar functions.)


Tory Zimmerman wrote:

When using the TEXT function I get the following message:

"Compile Error: Sub or Function not defined" It is
supposed to be a built in function such as Left$ or
Instr. It is in the help. If you can go to help, type in
functions and a list of all VBA functions come up click
on T then go to the TEXT function. I tried to duplicate
the example but still get the message about Sub or
Function not defined.

Call me if you care to

Tory
(714) 638-5714

--

Dave Peterson