Consulting

Results 1 to 4 of 4

Thread: Checklist: When table cell is clicked, make it green / white (not headers)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Jan 2016
    Posts
    10
    Location

    Checklist: When table cell is clicked, make it green / white (not headers)

    I have a simple table, 5 rows x 5 columns.
    The uppermost row and the leftmost column contains headers

    y y y y y
    z x x x x
    z x x x x
    z x x x x

    Each x cell contains some kind of text.

    I want to create a simple checklist where if I click cell x, that cell will become green (if not green) and the text inside becomes white.
    When I click the cell again, I want the green cell to revert back to white and the text to black

    Also the file should automatically save (not save as) when cell is clicked.

    I would like the macro to run directly when opening the powerpoint file.

    Total newbie at VBA so don't know how to do this?
    Last edited by jokris; 03-23-2019 at 10:56 AM. Reason: more info

Tags for this Thread

Posting Permissions

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