Input Masks in Excel?
Does Excel have input masks, similar to Access? I would like the user to
enter a date field but not have to insert the "/" marks. Example: enter 032405 and it would show up as 03/24/05. Thanks! -- Patti |
No, it's all manual.
-- HTH Bob Phillips "PattiP" wrote in message ... Does Excel have input masks, similar to Access? I would like the user to enter a date field but not have to insert the "/" marks. Example: enter 032405 and it would show up as 03/24/05. Thanks! -- Patti |
Thanks, Bob. I thought thats what the anwer might be...
"Bob Phillips" wrote: No, it's all manual. -- HTH Bob Phillips "PattiP" wrote in message ... Does Excel have input masks, similar to Access? I would like the user to enter a date field but not have to insert the "/" marks. Example: enter 032405 and it would show up as 03/24/05. Thanks! -- Patti |
Is there a way to convert the entry, i.e. 032405, and have it show up in
another cell in date format? Some kind of VB code? "Bob Phillips" wrote: No, it's all manual. -- HTH Bob Phillips "PattiP" wrote in message ... Does Excel have input masks, similar to Access? I would like the user to enter a date field but not have to insert the "/" marks. Example: enter 032405 and it would show up as 03/24/05. Thanks! -- Patti |
If you have got a lot, take a look at
http://www.xldynamic.com/source/xld.QDEDownload.html -- HTH Bob Phillips "PattiP" wrote in message ... Is there a way to convert the entry, i.e. 032405, and have it show up in another cell in date format? Some kind of VB code? "Bob Phillips" wrote: No, it's all manual. -- HTH Bob Phillips "PattiP" wrote in message ... Does Excel have input masks, similar to Access? I would like the user to enter a date field but not have to insert the "/" marks. Example: enter 032405 and it would show up as 03/24/05. Thanks! -- Patti |
or try this
Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then With Target .Value = DateSerial(Right(.Value, 2), Left(.Value, Len(.Value) - 4), Mid(.Value, Len(.Value) - 3, 2)) End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips "Bob Phillips" wrote in message ... If you have got a lot, take a look at http://www.xldynamic.com/source/xld.QDEDownload.html -- HTH Bob Phillips "PattiP" wrote in message ... Is there a way to convert the entry, i.e. 032405, and have it show up in another cell in date format? Some kind of VB code? "Bob Phillips" wrote: No, it's all manual. -- HTH Bob Phillips "PattiP" wrote in message ... Does Excel have input masks, similar to Access? I would like the user to enter a date field but not have to insert the "/" marks. Example: enter 032405 and it would show up as 03/24/05. Thanks! -- Patti |
All times are GMT +1. The time now is 10:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com