Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Calculation in UserForm TextBox
I am making a form to receive certain loan parameters and then
calculate certain other parameters. According to our rules, if the close date is 12/02/2003-01/01/2004, the First Payment Date is on 02/01/2004, and so on for every month. For some reason, the first day of each month is an odd-ball, but so be it. I came up with a spreadsheet formula that gives the correct first payment date for all close dates. =IF(DAY(B16)=1,DATE(YEAR(B16),(MONTH(B16)+1),(DAY( B16)-DAY(B16)+1)), DATE(YEAR(B16),(MONTH(B16)+2), (DAY(B16)-DAY(B16)+1))) where B16 is any close date. What I need to do is convert this into VBA code for a text box value after the close date is entered in another text box. At present, that is accomplished by the following. Public Sub UserForm_Activate() txtCloseDate.Value = Format(Now(), "mmmm d, yyyy") Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Format for Userform TextBox | New Users to Excel | |||
Need A date Mask format for a Textbox on UserForm | Excel Discussion (Misc queries) | |||
userform textbox | Excel Worksheet Functions | |||
Userform Textbox - Date Problem | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |