Trying to create a advanced control box
Solved/Closed
Ash
-
Jun 10, 2010 at 06:13 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 15, 2010 at 07:01 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 15, 2010 at 07:01 AM
Related:
- Trying to create a advanced control box
- Nvidia control panel download - Download - Other
- Create skype account with gmail - Guide
- Create a yahoo email account for free - Guide
- How to control f on a mac - Guide
- Create snapchat account - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 10, 2010 at 11:20 AM
Jun 10, 2010 at 11:20 AM
File not available there
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
Jun 11, 2010 at 09:05 AM
https://authentification.site/files/22907877/MT_Revenue_Regional_-_NE_Mar_09-10.zip
Password - buvadidaceti
Jun 11, 2010 at 10:24 AM
On the sheet "Account Details", there is a toggle button captioned "Control". On click on that a code is show which either shows a Userform or hides it.
If you want to put the toggle button, you would need to go to developer tab. If it is not visible then you need to go to Office Button ( the round thing on the top left corner ). Then go to Excel Options and click on Popular and check the "Show Developer tab in the Ribbon"
Jun 14, 2010 at 08:53 AM
Apologies - yes i wanted to find out how to create this box - as someone else has created it and I'd like to be able to create it. I can do a basic control box - but not to the level of how you'd go about having the option to show and hide data.
Jun 14, 2010 at 11:14 AM
The toggle button idea is either on and off
the code that you had, is bascially runs a macro. Depending if it is hide or or make visible columns, it does so.
Try to debug the code and and walk thru step a time using F8
Jun 15, 2010 at 06:54 AM