+ Reply to Thread
Results 1 to 4 of 4

Adding button/macro to add decimal

Hybrid View

  1. #1
    Registered User
    Join Date
    02-12-2007
    Posts
    2

    Adding button/macro to add decimal

    Hi all,

    Having some trouble in sorting a formula to link a macro to a button in the attached worksheet.

    Basically, it is an xls for a company car fleet. Under the 'Age of Vehicle (Months)' column, I am after a button being present for us to be able to press and for 0.1 to be added into every cars age.

    For instance, in Row 3 - Audi Q7 S Line, it is currently 0.3 months old, after pressing the button the age would then be increased to 0.4 months old.

    I would appreciate it if I could get some help sorting this

    Many thanks,

    Mike
    Attached Files Attached Files

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi Mike,

    See attached ...
    Cell E1 hides a counter ...
    Attached Files Attached Files
    HTH
    Carim


    Top Excel Links

  3. #3
    Registered User
    Join Date
    02-12-2007
    Posts
    2
    brilliant, thank you very much!!

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    You are welcome ...

    Thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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