spin control for date and time

What code are you currently using? You can use code similar to this (assuming the time is in cell A2)

Please Login or Register  to view this content.

Thanks BigBas. That worked when I deleted the Private on line one and when I deleted all format controls.
Your the best.
Ted

PS; How do a I show this solved?

I believe you click EDIT POST on your first post, then select Go Advanced. From there, I believe you can modify your title to solved.

And I'm glad I could be of assistance

HI. Thanks for everyone's help, but I found an issue. When I click the down arrow on the spin box, time moves forward and not backwards. Does anyone have a fix for this? Thanks again. Ted

You just have to enter the code into the appropriate event for the spinbutton. See the following code:

Please Login or Register  to view this content.

HI BIGBAS, I tried to enter your code. My VBA editor is making this into two seperate macros. When I paste your code, a line is inserted between the two routines. One is called SpinDown1 and the other is called SpinUp1. How can I assign two macros to one spin button? Thanks for your help again. Ted

It should be treated as two separate macros because they are two different events. Nonetheless, they refer to the same spinbutton.

Give it a try in a sample file. It should work. If not, let me know what kind of error you have and we can work around it

I am confused. I have been creating a new module in VBA Editor and pasteing your code. It creates two macros. One is called Spin up and the other is called Spin down. When I assign the macro to the spin button, it either goes up or down, depending on the which macor I assign, but not both ways. I so stupid when it comes to VBA. Thanks Ted

Maybe we should take a step back. Is this a Forms spinbutton or Control spinbutton? If you're not sure, right click on the spinbutton. Is there an option named View Code? If not, you are using a Forms spinbutton. Delete that, then go to View (in the main menu bar) -> TOOLBARS -> Control Toolbox. From there, select the spin button and add in where you'd like. Next, right click on the button, choose view code, and paste the code that I gave you into the module.

The final step is to go to back to the control toolbox, then click on the blue triangle (if you hover over it, it's called Design Mode). Once you do all that, the spinbutton SHOULD work. If not, can you post the workbook and I can add it for you

OK, That is working for me now. One more stupid question. How do I format the spin button? I need to adjust the size. When I right-click on it, it controls the input. Thanks for your help. I very much appreciate it.

---------- Post added at 12:25 PM ---------- Previous post was at 12:21 PM ----------

I got it. Thanks again. Ted

When working with a CONTROL spinbutton (or any object), you have to enter into Design mode (remember that Blue triangle). The blue triangle design mode button is a toggle button that turns design mode on and off. When design mode is on, you can format the item. If design mode is off, then the spinbutton is in use.

@ thmehr

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.