Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

July 2011 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Password Userform Module

    This was inspired by Dick Kusleika’s post Masking Passwords (http://www.dailydoseofexcel.com/archives/2011/07/12/masking-passwords/). It’s an enhanced version of DK’s approach in the sense that the same userform module supports both entering a new password as well as entering a password for confirmation. There are other enhancements. The user can choose to either mask or unmask [...] Read More...
    Filed under:

  • Extract the last token in a cell

    There are times when one wants to extract the last part of a string, say the file name from a string that contains the filename including the path. This short note describes a few ways to do that. The example we will use is the following. Cell A1 contains the value c:\x\yz.jpg. What [...] Read More...
    Filed under: ,

  • Masking Passwords

    Why do I keep creating userforms to get passwords? That’s it. This is the last time I’m doing it. From now on, I’ll just import UPassword.frm Here’s the code behind the form. Nothing special, I’m just tired of typing it. Option Explicit Private mbUserCancel As Boolean Private msPassword As String Public Property Get Password() As [...] Read More...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.