How to create a date mask and drop down list?

N

Nikos

I am not sure if this is the proper wording, but is their anyway t
create a standard date function/mark, to type dates in without havin
to type DASH, having to type out the entire year etc....

Also how can I create a drop downlist to choose from (that show
results when I type the first letter or second letter) in a column?

Any help with this would be greatly appreciated thanks

-Niko
 
N

Nikos

I am a little uncertain how to apply this code, I have never done i
before. How do I do it exactly so I don't mess up the program?

Is their anyway to do it without code?

Thank
 
G

Gord Dibben

Hard to mess up when you do something to a copy of the workbook.

Always best when learning to make a copy and work on that.

Which code are you speaking of? Chip's quickentry code?

Read his introductory instructions and should get an idea.

Chip's first set of code on that page is copied and pasted to a sheet module.

Copy the code and right-click on your sheet tab and "View Code".

Paste in there and start entering in A1:A10.

If you want a larger range, just edit the A1:A10 to whatever.

You can enter dates without the - or / but then you have to convert them later
so may as well do the - or/ to start with.

For the Autocomplete question, Debra has provided excellent instructions to
follow.


Gord
 
N

Nikos

The dates seem to work, but I also tried time and it says EVent_Chang
is an ambigous name? Why is that when it works for the date? Is i
because it can't do them both simultaneously? How do I get aroun
this
 
N

Nikos

Gord said:
You can enter dates without the - or / but then you have to conver
them later
so may as well do the - or/ to start with.
Click to expand...


What do you mean by convert them later? It seems to work fine for me
Is this in regards to if I want to export the data to another progra
such as Quickbooks or something
 
G

Gord Dibben

Convert them later means..................

You can type in a date like 20061223 which is not a real date.

You can convert this number to a date via a few different methods using formulas
or Data>Text to Columns.


Gord
 
Top