Auto fill cells!

[NickJW]

Hi

Thank you to those who helped me out last time.

I am using a spreadsheet and wish to be able to provide a 'Yes', 'No' radio button. If 'Yes' is selected, I would like the spreadsheet to show a hidden table with info relevant to the yes choice on it.

First, can I hide a table, and second, what kind of Macro would be needed to expose the data?

Thank you again

NickJW

[KiPA]

*offtopic*

More reasonable place to thank the previous guys would be that particular thread where they helped you

*offtopic*

[NickJW]

Good point KiPA thank you

[sweep]

Hi,

No code required. Use option buttons to control a cell value, and then use conditional formatting to "white out" the table based on the contents of that cell.

See attachment:



BTW - To express your thanks to folk that have helped you, how about clicking the blue scales on the top right of their post?!

[NickJW]

Thanks sweep. I have done so!

[NickJW]

Just a thought. Is there any way of hiding actual rows that contain the data rather than just hiding the data by reducing the colour to white? Still using the button controls when needed.
RSVP
NJW

[sweep]

You could assign this macro to a single button

Please Login or Register  to view this content.

to toggle the table, or assign code like this

Please Login or Register  to view this content.

to each of the option buttons. Further example is attached.