View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
christobal[_6_] christobal[_6_] is offline
external usenet poster
 
Posts: 1
Default Using Dates in VBA functions

For entering credit payment dates
On a userform I have a control which displays "Date" with a calenda
control to change the value.
If the day value is between the 1st and 15th inclusive, of the month
chosen, then I require that a listbox is populated with the result o
textbox "total amount" divided by textbox "number of payments
according to the 2nd of the consecutive month chosen for the "number o
payments" as number of rows in listbox.
If the day value is between 16th and Last day of month then the paymen
date will be the 8th of the consecutive month.
Is such a date calculation possible and if so then how

--
Message posted from http://www.ExcelForum.com