Thread: End of Month Function in Visual Basic
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fredriksson via OfficeKB.com Fredriksson via OfficeKB.com is offline
external usenet poster
  
Posts: 51
Default 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

Reply With QuoteReply With Quote