Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Ok I have one more question on my little project I'm working on. For those that have helped in guiding me, THANK YOU! This forum is actually really really great, I'm glad I found it! I've already told like 10 people about it. I simply have a text box field with a label name of, "Date." When a form loads in VBS the user is to enter a specific date. This date then stores in a cell on a particular worksheet. I currently have the text box set up so that no matter what you type in, it will store the value in the cell. However, I know there is a way to have the text box set up so that when the user types into it, the, "/"'s are already loaded and all they have to type is the numerical date. For example, the user would only have to type in, "932007" and the text box will show, "9/3/2007". Can someone help me in coding this text box so it's set up in this manner?? Also, how would I code a text box to automatically show a dollar sign ("$") in which it is to hold a dollar amount? Thanks!! -- chadtastic |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text to Columns not working correctly with dates in Excel 2007 | Excel Discussion (Misc queries) | |||
Working with Dates | Excel Worksheet Functions | |||
working with dates | Excel Discussion (Misc queries) | |||
Working with dates | Excel Worksheet Functions | |||
working with dates | Excel Discussion (Misc queries) |