+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 17 of 17

Update userform when user hides sheets

  1. #16
    Registered User
    Join Date
    12-09-2017
    Location
    israel
    MS-Off Ver
    windows 10
    Posts
    15

    Re: Update userform when user hides sheets

    Thank you so much keebellah for your comments!
    I will look into it when I get the chance

    A few things about what you wrote in your reply:

    I don't need the userform activated/showing at all times. This form should be loaded only when pressing another button, perhaps in the ribbon, where I will put it.

    The "sheets" button is just another setting option before the user can run a "reverse columns" macro which is aimed at reversing certain ranges' column order (while keeping every formatting aspect intact in them), in the sheets the user has selected (so that he/she doesn't have to run the "reverse column" macro manually for multiple sheets.


    I only stated the moduel name cause it makes readability easier. When a string of code stands on it own, I may confuse it with a variable when it is not.
    This also helps to immediately identify where it's coming from.. instead of using 'definition' which throws you off the scope of code that you're in). Is this bad practice or merely stating redundancy?

    I should probably have a hide sheet option too.. Didn't think about that..

    Again thank you, much appreciated!
    Last edited by guyglk; Yesterday at 01:40 AM.

  2. #17
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    4,374

    Re: Update userform when user hides sheets

    First thing is give the modules a fitting name, defaults Module1 Module2 etc are non-descriptive.
    A variable of a macro is not important, but if you add the module's name it makes it very maintenance unfriendly
    Happy coding
    Don'r forget to mark is SOLVED
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you ( It doesn't hurt )

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

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

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