Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form value passing problem
Hopefully this is a simple fix, but for some reason I can't figure it
out. I have a user from in which the user enters information through text boxes. One text box has characters and numbers, the rest have numbers. The one with mixed characters is a date. Specifically a month and year. The user is instructed to use an abbreviated form, i.e. June '06 or Sept. '06. The problem is that if the user inputs something like June 06 instead of June '06 (missing the apostrophe) or Sept 06 instead of Sept. 06 (no period), when I pass the value to a cell on a worksheet, I get a number. For example, July 06 = 38904 when passed using the code: Range("C27").Value2 = Me.txtMonth.Value I'd prefer to fix this without using data validation or anything like that. Thanks in advance for any advice! B |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form value passing problem
If you get a number then everything works fine. Just format the cell in date
format. Dates are really just numbers, counting number of days since new year to 1900 (or 1904). The real problem is when you /don't/ get a number, then it's just a date looking text and not a real date. Well maybe not. Maybe you don't want dates, just simple text. If so, preformnat the cell as text instead of date. HTH. Best wishes Harald skrev i melding oups.com... Hopefully this is a simple fix, but for some reason I can't figure it out. I have a user from in which the user enters information through text boxes. One text box has characters and numbers, the rest have numbers. The one with mixed characters is a date. Specifically a month and year. The user is instructed to use an abbreviated form, i.e. June '06 or Sept. '06. The problem is that if the user inputs something like June 06 instead of June '06 (missing the apostrophe) or Sept 06 instead of Sept. 06 (no period), when I pass the value to a cell on a worksheet, I get a number. For example, July 06 = 38904 when passed using the code: Range("C27").Value2 = Me.txtMonth.Value I'd prefer to fix this without using data validation or anything like that. Thanks in advance for any advice! B |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form value passing problem
Perfect, thanks for the fix and the info!
Harald Staff wrote: If you get a number then everything works fine. Just format the cell in date format. Dates are really just numbers, counting number of days since new year to 1900 (or 1904). The real problem is when you /don't/ get a number, then it's just a date looking text and not a real date. Well maybe not. Maybe you don't want dates, just simple text. If so, preformnat the cell as text instead of date. HTH. Best wishes Harald skrev i melding oups.com... Hopefully this is a simple fix, but for some reason I can't figure it out. I have a user from in which the user enters information through text boxes. One text box has characters and numbers, the rest have numbers. The one with mixed characters is a date. Specifically a month and year. The user is instructed to use an abbreviated form, i.e. June '06 or Sept. '06. The problem is that if the user inputs something like June 06 instead of June '06 (missing the apostrophe) or Sept 06 instead of Sept. 06 (no period), when I pass the value to a cell on a worksheet, I get a number. For example, July 06 = 38904 when passed using the code: Range("C27").Value2 = Me.txtMonth.Value I'd prefer to fix this without using data validation or anything like that. Thanks in advance for any advice! B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form Problem | Excel Discussion (Misc queries) | |||
User Form Problem | Excel Discussion (Misc queries) | |||
PASSING DATA FROM USER FORM TO EXCEL SPREADSHEET | Excel Programming | |||
passing a range to a user defined function using a form | Excel Programming | |||
Passing Text from User Form to Spreadsheet | Excel Programming |