#1   Report Post  
Member
 
Location: Sweden
Posts: 30
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
AutoSum CC New Users to Excel 12 October 29th 08 03:11 PM
autosum John Excel Discussion (Misc queries) 1 March 18th 08 06:15 PM
how do i set up autosum as a % Robert s Excel Worksheet Functions 1 February 7th 07 08:18 PM
AutoSum Carmel R Excel Worksheet Functions 4 November 6th 06 08:34 PM
AutoSum Alectrical Excel Worksheet Functions 4 August 11th 06 10:43 PM


All times are GMT +1. The time now is 08:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"