Making checkboxes not visible

I have a drop down on C23 with a few values let's say it's blue, green, yellow and red. Only If red is choosen I want my checkboxes/text and text to appear. For all others cell D23 should should be blank. I tried to use conditional formatting and this works fine but it doesn't make the checkboxes invisible.

How can I achieve this?

Thanks for your help!!!

Hi Elizabethd1012,

Check out this link, which may be of some help.

http://www.excelforum.com/excel-prog...lls-value.html

Regards.

I want something like:

Please Login or Register  to view this content.

But this is not working!

Post Deleted

Your code structure won't compile. Maybe ...

Please Login or Register  to view this content.

Hello Elizabethd1012,

Thank you for your kind co-operation.

We would need to see a sample of your Workbook, in order to provide you with a ready solution.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Thank you.

No luck what, Elizabeth? What's in C23? What happens when you set a breakpoint and step through the code?

http://www.cpearson.com/excel/DebuggingVBA.aspx

C23 would be the colors such as blue, green, yellow and red using a data validation drop down. I just want all the checkboxes to be present only when the color red is selected from the drop down.

I just want all the checkboxes to be present only when the color red is selected from the drop down.

Please Login or Register  to view this content.

This doesn't work. Nothing happens at all. I wish I could attach a sample but I'm at work and job doesn't allow uploads. Here is a screen shot if it helps.

\1

Elizabeth, there's no code in the workbook you uploaded. Right-click the Sheet1 tab, select View Code, and paste the code in the window that opens.

1. There's no dropdown in C23. It's in A1.

2. The checkboxes aren't Checkbox1/2/3 (names that would suggest they are ActiveX controls); they are forms controls named "Check Box 1", "Check Box 3", and "Check Box 4"

Please Login or Register  to view this content.

I just downloaded your workbook again, installed the code again, and ran it again. It works fine for me, Elizabeth. Maybe someone else can try.

Hi Elizabethd1012,

What shg has given you works perfectly on my side as well!

Maybe you should upload your Workbook, so that we can see what goes wrong on your side.

Regards.

@ shg,

Good work!!!

Hi Elizabethd1012,

Thank you for the feedback.

That is just great!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

I would also like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which you have been helped.

This adds to the reputation of the person who has taken the time to help you, and shg would surely appreciate it.

Thank you.