Thread: [Solved] Creating a date box
View Single Post
 
Old 05-11-2011, 03:27 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2007
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,342
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Philip,
Quote:
Originally Posted by Philip290 View Post
I'm still a beginner to Excel, so I don't know what textboxes/userforms are; this is just a basic excel sheet using stuff like =Date(...)
In that case, you need to learn the correct way of describing things. To refer to a textbox necessarily implies the use of a userform or an ActiveX control. If you want to work with cells on a worksheet, don't call them textboxes - call them cells. As you now know, adding a number to a date on a worksheet is very simple. Working with textboxes and userforms is not so simple and the solution is entirely different.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote