| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a VBA Function for WorksheetFunction.Text?
2003
Is there a VBA Function for WorksheetFunction.Text? TIA EagleOne |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a VBA Function for WorksheetFunction.Text?
Take a look at Format in VBA's help. It's not exactly the same, but similar.
Dennis wrote: 2003 Is there a VBA Function for WorksheetFunction.Text? TIA EagleOne -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a VBA Function for WorksheetFunction.Text?
Thanks Dave!
Dave Peterson wrote: Take a look at Format in VBA's help. It's not exactly the same, but similar. Dennis wrote: 2003 Is there a VBA Function for WorksheetFunction.Text? TIA EagleOne -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a VBA Function for WorksheetFunction.Text?
Just to be sure; I believe that you meant .FormatNumber because
Format() seems to apply to dates. EagleOne Dave Peterson wrote: Take a look at Format in VBA's help. It's not exactly the same, but similar. Dennis wrote: 2003 Is there a VBA Function for WorksheetFunction.Text? TIA EagleOne -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a VBA Function for WorksheetFunction.Text?
I really meant Format, as in:
Msgbox Format(1234.34,"$#,0.00") msgbox format(now,"yyyy_mm_dd__hh:mm:ss") Dennis wrote: Just to be sure; I believe that you meant .FormatNumber because Format() seems to apply to dates. EagleOne Dave Peterson wrote: Take a look at Format in VBA's help. It's not exactly the same, but similar. Dennis wrote: 2003 Is there a VBA Function for WorksheetFunction.Text? TIA EagleOne -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find WorksheetFunction - finding text within text | Excel Programming | |||
| Unable to get the Text property of the WorksheetFunction class | Excel Programming | |||
| application.worksheetfunction. <function (syntax) | Excel Programming | |||
| WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions? | Excel Programming | |||
| Using Excel WorksheetFunction.Mode function in Access VBA | Excel Programming | |||
Hybrid Mode
