need help with text boxes

[bhandari]

i have 4 check box (Ative x Control) OR form control check boxes
1)excellent
2)good
3)poor
4)very poor

if i click on marked on 1 check box

it must be visible IF i click "Excellent" check box or default this check box if no mark clicked
MERGED
A B C D E (MERGED CELLS) F G H(MERGED CELLS)
[TABLE="width: 820"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 5"]1 one : ……………………………………………………….
[/TD]
[TD="colspan: 3"]four : ……………………………………………………….
[/TD]
[/TR]
[TR]
[TD="colspan: 5"]2 two : ……………………………………………………….
[/TD]
[TD="colspan: 3"]five : ……………………………………………………….
[/TD]
[/TR]
[TR]
[TD="colspan: 5"]3 three : ………………………………………………………
[/TD]
[TD="colspan: 3"]six : ……………………………………………………….
[/TD]
[/TR]
</tbody>[/TABLE]
rest of 3 boxes
only visible like this in A1:G3
one: .......................

i need a macro for this

 

[bhandari]

If check box 1 marked text need to appear
Rest of 3 check boxes have sane text posted on 1st thread
If user didn't mark on any check box
Default one :checkbox1 text

 

[bhandari]

bump

 

[Joe4]

Cross-posted: https://www.excelforum.com/excel-programming-vba-macros/1213820-check-box-issue.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html).

This way, other members can see what has already been done in regard to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: http://www.excelguru.ca/content.php?184).