Speed up Coding

Hi Everyone,

First time writing VBA code and creating a "Program" as such. So i need some help. I have included my example document below.

Note
*The Modify Vehicle hasnt been coded as yet
*This workbook will be bigger. It will have Vehicle Servicing, Reports on Vehicles, Reports on spending ect.
*The Calendar userform and coding has been downloaded and copied from another website. (This runs quite slow)
*Im wanting to limit my VBA Reference Library as i will be sharing this with friends and i dont know what their computer will have.

Im looking at getting my coding checked to see if there is anything i can do to make it run faster or more efficiently (as the file will get alot bigger)
Im wanting to know as well if there is a better way to reference my Renewal OptionsButtons(Option3M, Option6M, Option12M) and they are also linked to Label(Rego_3M, Rego_6M, Rego_12M) as well as the new expiry date (New_Date label) updates depending on selection

Thank you so much

Thank you for the reply.
Can i remove the timer for the calendar all together? i dont use it.
the dwell timer for the change sheet is to make sure that it changes the sheet before opening up the userform. If i have it 1 digit lower it opens before changing sheets.
The tab order is all correct. How do i set focus to the next control? (is that by just writing the code at the end of the calendar one saying VCH_Rego.setfocus?
I have noticed that when you select a date the mouse load symbol just goes on. But as soon as you click somewhere else it stops.

The userform/Worksheet can be slow and lag. not sure if this is because of my laptop. But as its my first time writing VBA i wants pointers on where i can make it more efficient and run smoothly. I know i need to put Error handling in. But have no idea where to start with that either.

I have updated a few things.
*Rego Renewal i have created a function for the OptionButtons (Months3M, Months6M, Months12M) as well as the New date.
I have also linked this in with the saving to get the input option.

*Added Setfocus to the next object

i havent removed the timer as of yet. Waiting for a reply above.

Originally Posted by torachan

I will have a look through the whole code in the next day or two, are you committed to that actual calendar (it is code heavy on tracking mouse position) - I had to stop the timer to enable me to view the calendar form in the VBA editor (which is unusual).
From your profile I see you are using MS 365 o.s. however what version of Excel are you using and is it 32 bit or 64 bit.

Thank you.
I'm using MS 365 32bit.
I'm currently trying to change to rego ID dropdown on the renewal form. To only show regos that are due within the next 3 months (example. Select values from vehicle table if new rego is not blank then if new rego within 3 else if rego expiry date is within 3 months. But then if private or business is selected then it also only returns the values where it meets both values.