How to setup a cell to accept only one date then move to the next cell

[JP Pentz]

Hello,

This is my first post on here so sorry if this is posted in the wrong section but I figure you can never go wrong in general right? The question I have is I have an excel sheet that I want to use to enter date lest say in A1 and then automatically move to the next cell lets say A2 (downward)?
TIA

[alansidman]

Click on File, Options and then Advanced and check the box as shown below.Capture.JPG

[JP Pentz]

Good day Alansidman

A want to move to the next cell with out Pressing Enter Tab or Arrow
Can it be done.

[alansidman]

AFAIK--Only way is if you enact some sort of VBA macro. But then you would have to press enter to initiate the macro.

[JP Pentz]

Ok how will I go about to do this?
so then a will press enter ones to start the macro is that right

Thank you for you help

[alansidman]

You need to first decide what you want your macro to do, specifically, and then code is written to automate the steps that you would normally do manually.

[JP Pentz]

A want to enter the date in A1 and move to A2 with out Pressing Enter Tab or Arrow and
enter the date and move to A3 with out Pressing Enter Tab or Arrow AND SO ON AND SO ON.

[alansidman]

If you are entering data manually, then a macro will not work in this situation. AFAIK, if you are entering data manually, then you have to "Enter" it using one of the keys you don't want to touch.

[JP Pentz]

Now you lost me,
Let me explain like this a have a dropdown list of dates and a want excel to select the next date by it self
the dates is already inserted a will not be tipping the date in juts want excel to select the next date by it self.

[alansidman]

Ok, give me a realistic scenario. What is the start date and how will excel know what the next date is? How many rows to fill with dates and how will excel know each subsequent date?

[JP Pentz]

The dates will be lets say from 2018/06/01 and 02 and 03 and 04 up to 2018/06/30
so the rows will be from A1 up to A30.

[alansidman]

Here is some code to do that. Bed time. Signing out.

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[JP Pentz]

Work well then there's a run time error 13 what can that be?

[alansidman]

What does the error say, and when you get the error, and you click on debug, which line of code is highlighted. I am surprised as it worked for me before I posted it.

[JP Pentz]

No sorry its fine it was me
its all most what a want
Want excel to auto select a date and next date that is already there so it will be like a playback.