Consulting

Results 1 to 3 of 3

Thread: Text link to change table cell colour in Word?

  1. #1
    VBAX Newbie
    Joined
    Feb 2020
    Posts
    1
    Location

    Lightbulb Text link to change table cell colour in Word?

    Hi all,

    I'm not a programmer, but enjoy making documents with pizazz by copying your code!

    I'm making an evaluation form with lots of rows in standard tables within a Word document. Each row has the following scores 1 - Poor, 2 - Fair, 3 - Good, 4 - Very good, 5 - Excellent. I would like to make it so that the user can click on either the word or score (or both) to select the score at which point the background colour of the cell changes to indicate it has been selected.

    Is this possible?

    Thanks for your help!
    Sam.

  2. #2
    Microsoft Word MVP 2003-2009 VBAX Guru gmaxey's Avatar
    Joined
    Sep 2005
    Posts
    3,096
    Location
    Yes, however "clicking on the word or score" is a bit ambiguous. You could use the the WindowsSelectionChange event to see if you click in a cell and then see what that cells value is, or if you clicked in a Word what the words.range.text was. Seems it would make more sense to have a dropdown with the values then evaluate what was chosen in the dropdown.
    Greg

    Visit my website: http://gregmaxey.com

  3. #3
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    3,963
    Location
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

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
  •