+ Reply to Thread
Results 1 to 6 of 6

Is there an way to make this code/process more efficent ? (Alternative code/way/suggestion

  1. #1
    Registered User
    Join Date
    08-25-2016
    Location
    France
    MS-Off Ver
    2013 Professional Plus
    Posts
    6

    Question Is there an way to make this code/process more efficent ? (Alternative code/way/suggestion

    Hi,

    First of all thanks a ton for taking your time in reading my question.

    So my question is : I would like to display different tables and charts (related to that table) by just clicking buttons.

    Meaning to say : If I click on a button "CEO View", then I would like to see the custom view that I set up come in the existing excel sheet.

    Further Explanation : I setup an ActiveX Control (Command Button) and I used the code
    Please Login or Register  to view this content.
    Found the code here on this FORUM. I am still a newbie to VBA

    So I want to know if there any other alternative methods/ways to do this without using VBA and I get an error message when I run the above code. Could you also help me correct the code ?


    Thanks a ton for your help.
    Last edited by xcelRaj; 09-05-2016 at 07:38 AM. Reason: Mistake in the Post - 2

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Is there an way to make this code/process more efficent ? (Alternative code/way/sugges

    Hi,

    That is not the code from the thread to which you have linked. It should read
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    08-25-2016
    Location
    France
    MS-Off Ver
    2013 Professional Plus
    Posts
    6

    Re: Is there an way to make this code/process more efficent ? (Alternative code/way/sugges

    Thanks for the answer. I checked it, I used the right code on the excel sheet, but just mentioning here was wrong. Could you help me on the 2nd part of my question. Thanks a ton

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Is there an way to make this code/process more efficent ? (Alternative code/way/sugges

    If you wish to use a button rather than the menu items then you require a macro of some sort.

  5. #5
    Registered User
    Join Date
    08-25-2016
    Location
    France
    MS-Off Ver
    2013 Professional Plus
    Posts
    6

    Re: Is there an way to make this code/process more efficent ? (Alternative code/way/sugges

    can you kindly tell me how to make it with menu or direct me to some resources that shows how to do it. Thanks. Without knowing the exact name and kind even Google can't help

    Thanks for your help/ will wait for your reply

  6. #6
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Is there an way to make this code/process more efficent ? (Alternative code/way/sugges

    Select Excel's View tab, then press Custom Views and choose the view you wish to display. That is all I mean.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Modification suggestion(s) to speed up my code
    By VKS in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-14-2013, 06:28 AM
  2. Need help editing my code to make it repeat the process for every cell.
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-10-2012, 04:16 AM
  3. Converting Hex to Dec in VBA and making code efficent
    By NBVC in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-13-2009, 08:54 AM
  4. code explanation and suggestion
    By JohnSeito in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2007, 08:04 PM
  5. [SOLVED] code suggestion
    By sunkosi in forum Excel General
    Replies: 2
    Last Post: 05-04-2006, 10:30 PM
  6. Looking For A Suggestion About How To Write Code
    By abxy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2005, 03:15 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1