Customer Satisfaction Survey - Button 5 Not Working

**Rosco88** · 11-26-2013, 10:16 AM

Good Afternoon,

I am curerntly updating our Satisfaction Survey and I cannot get Row 5 on the lower section to correspond with column C.

Could somebody please take a look and tell me where I've gone wrong as I cannot see it.

Book2a.xlsm

Regards
Ross

**Richard Buttrey** · 11-26-2013, 10:25 AM

Hi,

The 5th option button is linked to C25 not C28.

Several of your other buttons are incorrect. You need to check them all.

**Richard Buttrey** · 11-26-2013, 10:35 AM

Hi,

You may also find the attached a more efficient method which avoids lots of control objects (although I've left them in place).

It uses conditional formatting to paint the cells green, although another option would be to use a Wingdings2 font and have the CF show Character Code 80 which is a tick symbol, or Wingdings with Character Code 74 which is a smiley face.