need help with text boxes

bhandari

Active Member
Joined
Oct 17, 2017
Messages
359
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)
1 one : ……………………………………………………….
four : ……………………………………………………….
2 two : ……………………………………………………….
five : ……………………………………………………….
3 three : ………………………………………………………
six : ……………………………………………………….

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
rest of 3 boxes
only visible like this in A1:G3
one: .......................

i need a macro for this
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

bhandari

Active Member
Joined
Oct 17, 2017
Messages
359
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
 
Last edited:

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,882
Office Version
  1. 365
Platform
  1. Windows
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).
 

Watch MrExcel Video

Forum statistics

Threads
1,122,224
Messages
5,594,916
Members
413,952
Latest member
JGer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top