Im looking for VBA way of calculating what day of the year is entered in a textbox this is going to be used to calculate the offset for the data on a userform to be placed in a specific column in the worksheet
Thank you for your help
Im looking for VBA way of calculating what day of the year is entered in a textbox this is going to be used to calculate the offset for the data on a userform to be placed in a specific column in the worksheet
Thank you for your help
Bramz
something like this
![]()
Dim i& i = DatePart("y", #2/5/2018#, vbUseSystemDayOfWeek, vbUseSystem) MsgBox i '36
Exactly what I needed
Thank You
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks