UserForm Template (Vault Code)

UserForm Template (Vault Code)

This code is the template code that you use when creating a Modal UserForm. This code was referenced in this Webinar.   The code below is the code that is placed in the UserForm. Your UserForm must have a button called Ok and Cancel. Set the Cancel property of...
CurrentRegion (Vault Code)

CurrentRegion (Vault Code)

CurrentRegion is a powerful method for returning a rectangular range of data   Description CurrentRegion returns a range of all the adjacent cells to the given range. In the screenshot below you can see the two current regions. I have added borders to make the...