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
*offtopic*
More reasonable place to thank the previous guys would be that particular thread where they helped you
*offtopic*
An example file is never useless!
Tried an example function of mine and got errors?
- Had you found them, replace ; with , and , with .
Good point KiPA thank you
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?!
Last edited by sweep; 11-25-2010 at 07:47 AM.
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
Thanks sweep. I have done so!
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
You could assign this macro to a single button
to toggle the table, or assign code like thisSub switch() Columns("H:L").EntireColumn.Hidden = Not Columns("H:L").EntireColumn.Hidden End Sub
to each of the option buttons. Further example is attached.Sub turnon() Columns("H:L").EntireColumn.Hidden = False End Sub Sub turnoff() Columns("H:L").EntireColumn.Hidden = True End Sub
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks