This is for a VBA TextBox (Not Worksheet).
I have two text boxes, both are going to have dates.
Textbox1 a user will enter a date; example 10/22/08 or 10-22-08 or 10-22-2008 etc, TextBox2 will get that date and add seven days.
How do I do that?
This obviously did not work.
Please Login or Register to view this content.
Last edited by Rick_Stanich; 10-22-2008 at 05:25 PM.
Regards
Rick
Win10, Office 365
Hi Rick. Try:
CDate converts the TextBox1 value (which is a string) into a date before adding 7 days.Please Login or Register to view this content.
HTH
Jason
Thank you Jason, I need to remember formatting.
No problem Rick. The formatting really didn't have anything to do with your problem, although I thought I would throw that in there.Your issue was you were trying to add 7 to a string (text), rather than a date. A text box always returns a string, so you need to convert it (hence the use of CDate).
Jason
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks