I'm looking for some help. I'm new to coding and have started creating this Vehicle database program in Exceul for a friend to use.

He is wanting to be able to see all vehicles he owns, when registration is due as well as input any vehicle services that have been done.
 

• I have created a Userform in Excel, one for adding a Vehicle and renewing Registration.
   
• This is working but I believe it isn't very efficient.
   
• Once I looked into it more and studied it more, I found that you shouldn't put information in the form as such and it is just a presenter and it should be read through modules and classes.
   
• I have tried doing this and I just get stuck and cant do it or get it to work. is this required or any in my coding to be fixed?
   

On the Vehicle form they fill out their Vehicle Details.

• They input TextBox (Date of purchase, Regonumber, Rego Expiry, Purchase Price, Kms at Purchase, The Vehicle VIN, Make, Model).
  
• ComboBox (Year of Vehicle, Colour of Vehicle, Type of Vehicle (Car, Light Rigid, Motorbike ect), Fuel Type (Unleaded Diesel ect), Premium Class (To do with our state registration), Transmission Type (Automatic, Manual), Usage Type Whether they use the Vehice for Private or Business)
  If they input Purchase price at a date after today it pops up the Invalid date and makes the textbox red, If the Expiry Date is more that 4months ago the same thing happens.
  
• The Purchase Date, (Rego, Expiry = IF the Unregistered button isnt ticked), Year, Make, Model, Vehicle Type, Transmission type and Usage is required to be filled out to submit the vehicle to the table.
   
• When they click Add it adds it to the Table and unloads. If they click cancel a messagebox pops up to confirm, if yes then it just unloads.

With the Registration Renewal form
 

• The ComboBox has the Vehicle registrations from the Vehicle table where the vehicle hasnt been marked as disposed or unregistered and the Vehicle Expiry date is after Today-4Months and before Today+4Months.
   
• If they Select either Private or Business it clears all selections and populates the Registration Combobox with the Above conditions but also filters and only populates the vehicles relevant to the selection (Private or Business)
   
• Once a vehicle has been selected then there is 4 Label boxes under the Registration Combobox that populates the information from selected. (I will provide a photo of this. It also populates the Registration Expiry date and makes the Renewal period Options appear (3Months, 6Months, 12Months)
   
• Once one of the renewal periods are selected it populates the New Expiry date Label.
   
• You input the total. If you want to complete more renewals you select the More Renewals tick box.
   
• You then press add, it inputs all the data in the Renewals Table as well as update the Expiry date in the Vehicles table.
   
• If the More Renewals box was ticked it returns the form in a cleared state to update another Registration Expiry otherwise it unloads.
   
• If you press cancel a warning pops up and if you press ok it unloads

I'm looking for some help. I'm new to coding and have started creating this Vehicle database program in Excel for a friend to use.

He is wanting to be able to see all vehicles he owns, when registration is due as well as input any vehicle services that have been done.

• I have created a User form in Excel, one for adding a Vehicle and renewing Registration.
• This is working but I believe it isn't very efficient.
• Once I looked into it more and studied it more, I found that you shouldn't put information in the form as such; it is just a presenter and it should be read through modules and classes.
• I have tried doing this and I just get stuck and can't do it or get it to work. Is this required or is anything else in my coding to be fixed?

On the Vehicle form they fill out their Vehicle Details:

• text boxes (Date of purchase, Regonumber, Rego Expiry, Purchase Price, Kms at Purchase, the VIN, Make, Model)
• choices (Year of Vehicle, Colour of Vehicle, Type of Vehicle (Car, Light Rigid, Motorbike etc.), Fuel Type (Unleaded Diesel etc.), Premium Class (to do with our state registration), Transmission Type (Automatic, Manual), Usage Type (whether they use the vehicle for Private or Business)

If they input Purchase price at a date after today it pops up an invalid date warning and makes the textbox red; if the Expiry Date is more than 4 months ago the same thing happens.

• The Purchase Date, (Rego, Expiry - if the Unregistered button isn't ticked), Year, Make, Model, Vehicle Type, Transmission type and Usage is required to be filled out to submit the vehicle to the table.
• When they click Add it adds it to the Table and unloads. If they click Cancel, a message box pops up to confirm, if yes then it just unloads.

With the Registration Renewal form:

• The ComboBox has the Vehicle registrations from the Vehicle table where the vehicle hasn't been marked as disposed or unregistered and the Vehicle Expiry date is within 4 months of today.
• If they Select either Private or Business it clears all selections and populates the Registration Combobox with the above conditions but also filters and only populates the vehicles relevant to the selection (Private or Business).
• Once a vehicle has been selected then there are 4 Label boxes under the Registration Combobox that populate the information from selected. (I will provide a photo of this). It also populates the Registration Expiry date and makes the renewal period options appear (3 Months, 6 Months, 12 Months).
• Once one of the renewal periods are selected it populates the New Expiry date Label.
• You input the total. If you want to complete more renewals you select the More Renewals tick box.
• You then press Add; it inputs all the data in the Renewals Table and updates the Expiry date in the Vehicles table.
• If the More Renewals box was ticked it returns the form in a cleared state to update another Registration Expiry otherwise it unloads.
• If you press cancel a warning pops up and if you press okay it unloads.

Im looking for some help. Im new to coding and have started creating this Vehicle database/program in Excel for a friend to use. He is wanting to be able to see all vehicles he owns, when registration is due as well as input any vehicle services that have been done.
I have created a Userform in Excel, one for adding a Vehicle and renewing Registratation.
This is working but i believe it isn't very effiecent.
Once i looked into it more and studied more i had found that you shouldn't put information in the form as such and it is just a presenter and it should be read through modules and classes.
I have tried doing this and i just get stuck and cant do it or get it to work. is this required or any in my coding to be fixed?
*Please note that i didn't write the code for the calendar, hidebar or switch off. I can provide the codes to them if required.

On the Vehicle form they fill out their Vehicle Details.
They input TextBox (Date of purchase, Regonumber, Rego Expiry, Purchase Price, Kms at Purchase, The Vehicle VIN, Make, Model).
ComboBox (Year of Vehicle, Colour of Vehicle, Type of Vehicle (Car, Light Rigid, Motorbike ect), Fuel Type (Unleaded Diesel ect), Premium Class (To do with our state registration), Transmission Type (Automatic, Manual), Usage Type Whether they use the Vehice for Private or Business)
If they input Purchase price at a date after today it pops up the Invalid date and makes the textbox red, If the Expiry Date is more that 4months ago the same thing happens.
The Purchase Date, (Rego, Expiry = IF the Unregistered button isnt ticked), Year, Make, Model, Vehicle Type, Transmission type and Usage is required to be filled out to submit the vehicle to the table.
When they click Add it adds it to the Table and unloads. If they click cancel a messagebox pops up to confirm, if yess then it just unloads.

With the Registration Renewal form
The ComboBox has the Vehicle registrations from the Vehicle table where the vehicle hasnt been marked as disposed or unregistered and the Vehicle Expiry date is after Today-4Months and before Today+4Months.
If they Select either Private or Business it clears all selections and populates the Registration Combobox with the Above conditions but also filters and only populates the vehicles relevant to the selection (Private or Business)
Once a vehicle has been selected then there is 4 Label boxes under the Registration Combobox that populates the information from selected. (I will provide a photo of this. It also populates the Registration Expiry date and makes the Renewal period Options appear (3Months, 6Months, 12Months)
Once one of the renewal periods are selected it populates the New Expiry date Label.
You input the total. If you want to complete more renewalss you select the More Renewals tick box.
You then press add, it inputs all the data in the Renewals Table as well as update the Expiry date in the Vehicles table.
If the More Renewals box was ticked it returns the form in a cleared state to update another Registration Expiry otherwise it unloads.
if you press cancel a warning pops up and if you press ok it unloads

I'm looking for some help. I'm new to coding and have started creating this Vehicle database program in Exceul for a friend to use.

He is wanting to be able to see all vehicles he owns, when registration is due as well as input any vehicle services that have been done.

• I have created a Userform in Excel, one for adding a Vehicle and renewing Registration.
  
• This is working but I believe it isn't very efficient.
  
• Once I looked into it more and studied it more, I found that you shouldn't put information in the form as such and it is just a presenter and it should be read through modules and classes.
  
• I have tried doing this and I just get stuck and cant do it or get it to work. is this required or any in my coding to be fixed?
  

Please note that I didn't write the code for the calendar, hidebar or switch off. I can provide the code to them if required.

On the Vehicle form they fill out their Vehicle Details.

• They input TextBox (Date of purchase, Regonumber, Rego Expiry, Purchase Price, Kms at Purchase, The Vehicle VIN, Make, Model).
  
• ComboBox (Year of Vehicle, Colour of Vehicle, Type of Vehicle (Car, Light Rigid, Motorbike ect), Fuel Type (Unleaded Diesel ect), Premium Class (To do with our state registration), Transmission Type (Automatic, Manual), Usage Type Whether they use the Vehice for Private or Business)
  If they input Purchase price at a date after today it pops up the Invalid date and makes the textbox red, If the Expiry Date is more that 4months ago the same thing happens.
  
• The Purchase Date, (Rego, Expiry = IF the Unregistered button isnt ticked), Year, Make, Model, Vehicle Type, Transmission type and Usage is required to be filled out to submit the vehicle to the table.
  
• When they click Add it adds it to the Table and unloads. If they click cancel a messagebox pops up to confirm, if yes then it just unloads.

With the Registration Renewal form

• The ComboBox has the Vehicle registrations from the Vehicle table where the vehicle hasnt been marked as disposed or unregistered and the Vehicle Expiry date is after Today-4Months and before Today+4Months.
  
• If they Select either Private or Business it clears all selections and populates the Registration Combobox with the Above conditions but also filters and only populates the vehicles relevant to the selection (Private or Business)
  
• Once a vehicle has been selected then there is 4 Label boxes under the Registration Combobox that populates the information from selected. (I will provide a photo of this. It also populates the Registration Expiry date and makes the Renewal period Options appear (3Months, 6Months, 12Months)
  
• Once one of the renewal periods are selected it populates the New Expiry date Label.
  
• You input the total. If you want to complete more renewals you select the More Renewals tick box.
  
• You then press add, it inputs all the data in the Renewals Table as well as update the Expiry date in the Vehicles table.
  
• If the More Renewals box was ticked it returns the form in a cleared state to update another Registration Expiry otherwise it unloads.
  
• If you press cancel a warning pops up and if you press ok it unloads

On the Vehicle form they fill out their Vehicle Details.<br> They input TextBox (Date of purchase, Regonumber, Rego Expiry, Purchase Price, Kms at Purchase, The Vehicle VIN, Make, Model). <br> ComboBox (Year of Vehicle, Colour of Vehicle, Type of Vehicle (Car, Light Rigid, Motorbike ect), Fuel Type (Unleaded Diesel ect), Premium Class (To do with our state registration), Transmission Type (Automatic, Manual), Usage Type Whether they use the Vehice for Private or Business)<br> If they input Purchase price at a date after today it pops up the Invalid date and makes the textbox red, If the Expiry Date is more that 4months ago the same thing happens.<br> The Purchase Date, (Rego, Expiry = IF the Unregistered button isnt ticked), Year, Make, Model, Vehicle Type, Transmission type and Usage is required to be filled out to submit the vehicle to the table.<br> When they click Add it adds it to the Table and unloads. If they click cancel a messagebox pops up to confirm, if yess then it just unloads.

With the Registration Renewal form
The ComboBox has the Vehicle registrations from the Vehicle table where the vehicle hasnt been marked as disposed or unregistered and the Vehicle Expiry date is after Today-4Months and before Today+4Months. <br> If they Select either Private or Business it clears all selections and populates the Registration Combobox with the Above conditions but also filters and only populates the vehicles relevant to the selection (Private or Business) <br> Once a vehicle has been selected then there is 4 Label boxes under the Registration Combobox that populates the information from selected. (I will provide a photo of this. It also populates the Registration Expiry date and makes the Renewal period Options appear (3Months, 6Months, 12Months) <br> Once one of the renewal periods are selected it populates the New Expiry date Label. <br> You input the total. If you want to complete more renewalss you select the More Renewals tick box. <br> You then press add, it inputs all the data in the Renewals Table as well as update the Expiry date in the Vehicles table. <br> If the More Renewals box was ticked it returns the form in a cleared state to update another Registration Expiry otherwise it unloads. <br> if you press cancel a warning pops up and if you press ok it unloads

On the Vehicle form they fill out their Vehicle Details. 
They input TextBox (Date of purchase, Regonumber, Rego Expiry, Purchase Price, Kms at Purchase, The Vehicle VIN, Make, Model).  
ComboBox (Year of Vehicle, Colour of Vehicle, Type of Vehicle (Car, Light Rigid, Motorbike ect), Fuel Type (Unleaded Diesel ect), Premium Class (To do with our state registration), Transmission Type (Automatic, Manual), Usage Type Whether they use the Vehice for Private or Business) 
If they input Purchase price at a date after today it pops up the Invalid date and makes the textbox red, If the Expiry Date is more that 4months ago the same thing happens. 
The Purchase Date, (Rego, Expiry = IF the Unregistered button isnt ticked), Year, Make, Model, Vehicle Type, Transmission type and Usage is required to be filled out to submit the vehicle to the table. 
When they click Add it adds it to the Table and unloads. If they click cancel a messagebox pops up to confirm, if yess then it just unloads.

With the Registration Renewal form
The ComboBox has the Vehicle registrations from the Vehicle table where the vehicle hasnt been marked as disposed or unregistered and the Vehicle Expiry date is after Today-4Months and before Today+4Months.  
If they Select either Private or Business it clears all selections and populates the Registration Combobox with the Above conditions but also filters and only populates the vehicles relevant to the selection (Private or Business)  
Once a vehicle has been selected then there is 4 Label boxes under the Registration Combobox that populates the information from selected. (I will provide a photo of this. It also populates the Registration Expiry date and makes the Renewal period Options appear (3Months, 6Months, 12Months)  
Once one of the renewal periods are selected it populates the New Expiry date Label.  
You input the total. If you want to complete more renewalss you select the More Renewals tick box.  
You then press add, it inputs all the data in the Renewals Table as well as update the Expiry date in the Vehicles table.  
If the More Renewals box was ticked it returns the form in a cleared state to update another Registration Expiry otherwise it unloads.  
if you press cancel a warning pops up and if you press ok it unloads