View Single Post
 
Old 07-18-2018, 06:08 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try the attached. I needed to make some minor changes to your table (including restoration of the placeholder texts), but that won't affect its utility.

Note: If you want to shade the output cells to match the ratings, you could change:
Code:
  .Range.Tables(1).Cell(r, c).Range.Text = StrTxt
to:
Code:
  With .Range.Tables(1).Cell(r, c)
    .Range.Text = StrTxt
    .Shading.BackgroundPatternColor = Tbl.Cell(i + 1, j + 1).Shading.BackgroundPatternColor
  End With
Do note, though, that this will apply the light grey shading to those cells if you click through them without making a selection. Making that the default state might work for you.
Attached Files
File Type: dotm Scouts Risk Assessment.dotm (64.5 KB, 30 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote