Display/Hide radio buttons

Hi 6StringJazzer

Where should I apply this code?

Originally Posted by 6StringJazzer

Here is the idea:

OptionButton1.Visible = (Range("E5") <> "")

This would need to be repeated for each button. If your buttons have a regular naming scheme, such as OptionButton1 through OptionButton16 then I think you can do this with a loop but I would have to look up the details.

Where are the radio buttons? In a worksheet, or in a userform?

In a worksheet.

Originally Posted by 6StringJazzer

Where are the radio buttons? In a worksheet, or in a userform?

At this point it's going to be better if you attach your file. Otherwise I am going to have to create a file and try to imagine what yours looks like, which would take a lot of time.

To attach a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
3. In the pop-up, click Add then Select to select a file from your local drive
4. Click the Upload button to upload the file
5. Click Done to attach it.

It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.

Here are step-by-step instructions with screen shots

Hi 6StringJazzer! Sorry for the delay!

Here is the file.
Reference Guide - New.xlsm
Besides the dummy data, everything else is real.
You can search for "1", "2", "3", etc. When searching for "1", for example, only one line is fulfilled and my intention is to hide the radio buttons that correspond to no results.
So: If B9 is empty OptionButton3 is hidden.

Does this help?

Thanks again!

Someone? Please?