Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
You can do this as follows
Copy following code and paste into your macro’s code window Private Sub addDate() If TextBox1.Value = "" Then Exit Sub If TextBox2.Value = "" Then Exit Sub TextBox3.Value = CDate(TextBox1.Value) + CDbl(TextBox2.Value) End Sub Private Sub TextBox1_Change() Call addDate End Sub Private Sub TextBox2_Change() Call addDate End Sub Have a nice time.... Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AutoSum | New Users to Excel | |||
autosum | Excel Discussion (Misc queries) | |||
how do i set up autosum as a % | Excel Worksheet Functions | |||
AutoSum | Excel Worksheet Functions | |||
AutoSum | Excel Worksheet Functions |