Results 1 to 9 of 9

Speed up Coding

Threaded View

  1. #1
    Registered User
    Join Date
    07-03-2023
    Location
    Tasmania, Australia
    MS-Off Ver
    Microsoft 365
    Posts
    5

    Post 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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Speed controls, how to calculate average speed.
    By Hejhallo in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-07-2022, 06:33 AM
  2. Speed up the macro coding 150 sheets
    By rajuganapathy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2019, 08:53 AM
  3. Speed up the macro coding
    By rajuganapathy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-26-2019, 10:39 PM
  4. How to avoid cell SELECTION but still format cells to speed up the macro running speed
    By BeefyBerts in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2018, 08:18 AM
  5. [SOLVED] In need of help regarding combo box coding and button coding (Access form project)
    By mailblade in forum Access Tables & Databases
    Replies: 2
    Last Post: 01-09-2016, 01:34 AM
  6. Everage Speed km/time (european speed)
    By GerryZucca in forum Excel General
    Replies: 3
    Last Post: 02-23-2015, 03:02 PM
  7. How to make VBA offset and speed up coding
    By Toyo613 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-05-2014, 10:34 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1