Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 versus 2003 and the TEXT Function | Excel Worksheet Functions | |||
Excel 2000 Text | Excel Worksheet Functions | |||
EXCEL 2000 AVERAGE function | Excel Worksheet Functions | |||
round function in excel 2000 | Excel Worksheet Functions | |||
IF/ LOOKUP FUNCTION - Excel 2000 | Excel Worksheet Functions |