| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
End of Month Function in Visual Basic
I would like to initialize a text box in a user form with the last day of the
month calculated from the current date (Today) I tried the following: Private Sub UserForm_Initialize() Me.AcctPeriodInputBox.Value = EOMONTH(Date) End Sub How do I use Functions that are in Excel to calculate values in a macro? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200701/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How should I do this (function or Visual basic) | Excel Worksheet Functions | |||
| Call a Visual Basic Function with VLookup | Excel Worksheet Functions | |||
| Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
| Call XLA function in Visual Basic Macro ? | Excel Programming | |||
| How do I use an array function in Visual basic .NET? | Excel Programming | |||
Threaded Mode
