Trying to create a advanced control box

Solved/Closed
Ash - Jun 10, 2010 at 06:13 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jun 15, 2010 at 07:01 AM
Hello,

I'm wondering how the control box in the attached sheet can be created in Excel 2007 - i want to create it in one of my sheets

http://ifile.it/y9b1aec/MT%20Revenue%20Regional%20-%20NE%20Mar%2009-10.zip

Thanks
Ash

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 11, 2010 at 10:24 AM
You did not explain exactly what you are looking for.

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"
0
Hi

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.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 14, 2010 at 11:14 AM
Well I think I did tell you how to create one. If you need far more detail, then you would have to look at the code.

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
0
thanks:-)
0