MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linking an option box to a table


Posted by Gail on October 22, 2001 10:19 AM

I have 30 option boxes in a form. I want to know if I can link the option box to a table (approx 30 columns and 30-40 rows per table). The tables are on separate sheets in the same workbook. Any help on this would be appreciated. Please Please Please help!!! Thanks in advance.


Posted by Stan on October 22, 2001 10:39 AM

Gail

What do you want the "linking" to do?

Stan

Posted by Gail on October 22, 2001 11:59 AM

Hi Stan,
When one of the 30 option boxes is clicked I want a specific table to be displayed. Each option box has its own table. So basically as the selected option box changes, a different table specific to that box should be diaplayed. I hope i have answered the question without being cricular.

Thanks..

Posted by Stan on October 23, 2001 5:54 AM

Gail

It sounds like you simply want to open a specific worksheet depending on what option button is selected.

Try this:

Private Sub OptionButton1_Click()
Sheets("Sheet2").Activate
end sub

Just replace the name of the worksheet (e.g. "Sheet 2") for each option button.

Stan


Posted by Gail on October 23, 2001 8:16 AM

Hey Stan,
Thanks a lot for helping a VB illiterate person :)