| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input mask on a form in Excel 2003
Hi My name is Lloyd
I know MS Access quite well, can you help me I want to put input mask to a date on a field in a form in Excel eg. 2006/08/08. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Input mask on a form in Excel 2003
there is no support for this. You would need to use the change event for the
textbox to validate the entry. -- Regards, Tom Ogilvy "Lloyd" wrote: Hi My name is Lloyd I know MS Access quite well, can you help me I want to put input mask to a date on a field in a form in Excel eg. 2006/08/08. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Input mask on a form in Excel 2003
Hi Tom
where do I find change event for the textbox. Thanks "Tom Ogilvy" wrote: there is no support for this. You would need to use the change event for the textbox to validate the entry. -- Regards, Tom Ogilvy "Lloyd" wrote: Hi My name is Lloyd I know MS Access quite well, can you help me I want to put input mask to a date on a field in a form in Excel eg. 2006/08/08. Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Input mask on a form in Excel 2003
Hi Tom
Sorry maybe I did not explain myself. I am working in Excel VBA "Tom Ogilvy" wrote: there is no support for this. You would need to use the change event for the textbox to validate the entry. -- Regards, Tom Ogilvy "Lloyd" wrote: Hi My name is Lloyd I know MS Access quite well, can you help me I want to put input mask to a date on a field in a form in Excel eg. 2006/08/08. Thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Input mask on a form in Excel 2003
Yes, I understand that. I assumed you mean using userform or a textbox from
the control toolbox toolbar. If not, where do you want to validate the data? If you mean in a cell, then look at Data=Validation -- Regards, Tom Ogilvy "Lloyd" wrote: Hi Tom Sorry maybe I did not explain myself. I am working in Excel VBA "Tom Ogilvy" wrote: there is no support for this. You would need to use the change event for the textbox to validate the entry. -- Regards, Tom Ogilvy "Lloyd" wrote: Hi My name is Lloyd I know MS Access quite well, can you help me I want to put input mask to a date on a field in a form in Excel eg. 2006/08/08. Thanks |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Input mask on a form in Excel 2003
Yes I mean userform in a VBAProject (TextBox)
"Tom Ogilvy" wrote: Yes, I understand that. I assumed you mean using userform or a textbox from the control toolbox toolbar. If not, where do you want to validate the data? If you mean in a cell, then look at Data=Validation -- Regards, Tom Ogilvy "Lloyd" wrote: Hi Tom Sorry maybe I did not explain myself. I am working in Excel VBA "Tom Ogilvy" wrote: there is no support for this. You would need to use the change event for the textbox to validate the entry. -- Regards, Tom Ogilvy "Lloyd" wrote: Hi My name is Lloyd I know MS Access quite well, can you help me I want to put input mask to a date on a field in a form in Excel eg. 2006/08/08. Thanks |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Input mask on a form in Excel 2003
double click on the textbox in the VBE and it should take you to the change
event. Or right click on it and select view code. -- Regards, Tom Ogilvy "Lloyd" wrote: Yes I mean userform in a VBAProject (TextBox) "Tom Ogilvy" wrote: Yes, I understand that. I assumed you mean using userform or a textbox from the control toolbox toolbar. If not, where do you want to validate the data? If you mean in a cell, then look at Data=Validation -- Regards, Tom Ogilvy "Lloyd" wrote: Hi Tom Sorry maybe I did not explain myself. I am working in Excel VBA "Tom Ogilvy" wrote: there is no support for this. You would need to use the change event for the textbox to validate the entry. -- Regards, Tom Ogilvy "Lloyd" wrote: Hi My name is Lloyd I know MS Access quite well, can you help me I want to put input mask to a date on a field in a form in Excel eg. 2006/08/08. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel input mask for textbox | Excel Discussion (Misc queries) | |||
| input mask in excel | Excel Worksheet Functions | |||
| input mask in excel sheet | Excel Worksheet Functions | |||
| Excel 97, text box Input Mask, local date format | Excel Programming | |||
| Mask input in input boxes? | Excel Programming | |||
Linear Mode
