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

Browse Site by Tags

Showing related tags and posts accross the entire site.
  • Amazon Linkerator

    Since I can’t install JPSoftwareTech’s Amazon link generator, I decided to write my own. Fewer features, less choice because that’s how I roll. I recommend JP’s version – it’s very well done. My tastes and habits are very quirky, so this “utility” is very...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Wed, Mar 13 2013
  • An MSForms Treeview

    If you have ever used the Treeview control from the “Additional controls” section, then you know what a versatile control this is to show hierarchically organized data. There are a couple of problems with this Treeview control: Compile errors due to a difference in how the control libraries...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Thu, Jan 31 2013
  • Excel 2013, SDI and modeless userforms

    Hi Everyone, With Excel 2013 we also got new document windowing in Excel; Microsoft decided to make Excel behave the same as Word: from MDI: to SDI: This causes havoc when one shows a modeless userform which should stay on top of all Excel windows: I’ve devised a way to prevent this problem and...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Mon, Nov 26 2012
  • 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...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Tue, Jul 12 2011
  • Add userform controls on the fly

    For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/1051 Add userform items on the fly.shtml Tushar Mehta
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Tue, Mar 29 2011
  • Adding Functionality - 2a

    Dick Kusleika’s VBE Find is useful enough that it justifies the resources need to enhance it. In addition to adding Regular Expression searching (Adding functionality - I) a sort capability made sense since since the results include code from multiple code modules and procedures within them. The...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Sat, Feb 12 2011
  • Distributing controls in a userform

    On many occasions there is a need to lay out controls horizontally in a userform so that they are equally spaced and, as a group, centered within the userform. An example is the group of three buttons (OK, Cancel, and Help) in the userform below. The worksheet below calculates the left position of...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Tue, Jan 11 2011
  • Related Sheets Stack

    In Previous Sheets Stack, I created a historical list of sheets visited on the right click menu for easier navigation. After reading the comments, I decided to change the whole approach. Now I show related sheets (which I define) in a userform. Related Sheets I'm dealing with inventory assemblies...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Fri, Apr 24 2009
  • Sizing Listbox Columns

    In my DDoE Quick TTC utility, I split text out into separate listbox columns. That means the column widths are always changing. Jan Karel has a very nice write-up on autosizing listbox columns. Based on that, I wrote the below procedure. I used the hidden label technique that JKP suggested. Instead...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Mon, Mar 2 2009
  • My own Euler problem

    Hi everyone, With all these Euler posts I thought, why not post my own? Suppose the following: I have a products table set up like this: Code ProdName Price 0001 Product1 556.68 0002 Product2 977.41 0003 Product3 350.62 0004 Product4 509.16 0005 Product5 748.4 0006 Product6 802.96 (list goes on to as...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Tue, Feb 17 2009
Page 1 of 1 (10 items)
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.