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.
  • Installation Instructions for Office add-ins

    I updated the installation instructions for Office VBA add-ins to include Office 2010, Office 2007, and Office 2003. The updated material is at http://www.tushar-mehta.com/excel/software/installation/index.htm. Tushar Mehta
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Sun, Jun 17 2012
  • Minimum and maximum values of numeric data types

    There has been many an occasion when I have wanted programmatic access to the maximum or minimum or smallest value of a data type. Some programming languages have built-in support through names like MaxInt. VBA, unfortunately, is not one of them. I decided to “translate” the documentation defining the...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Tue, Jun 12 2012
  • Using the “short date”, “medium date” and “long date” formats

    I came across a line of code that formatted a date in VBA like this: Format(aDate,”short date”). And I didn’t get it. So with a little investigation, it turns out that “short date” (and “medium date” and “long date”) relate to the specified system...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Tue, Jun 5 2012
  • Ease of reuse of modular code

    The primary reason I write modular code is that it is self-documenting, easy to understand, and easy to maintain. A secondary reason is the ease of reuse. One of the comments to my post Two new range functions: Union and Subtract (www.dailydoseofexcel.com/archives/2007/08/17/two-new-range-functions...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Fri, Aug 19 2011
  • ByVal or ByRef Parameters

    Procedure arguments, either for a subroutine or a function, are declared either as ByVal or ByRef. The use of ByVal means that the called procedure does not want to change the value of the argument passed to it whereas the use of ByRef means that the called procedure may change the value. This note...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Tue, Jun 7 2011
  • Visualize Data with Shapes on a Map

    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/13-03%20Shapes%20on%20a%20Map.shtml Tushar Mehta
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Mon, Feb 28 2011
  • VBE Find - 2

    Dick Kusleika shared VBE Find, a solution that intentionally had no choices and a straightforward UI. [In his post he also pointed out a few limitations with it.] Unfortunately for him, I liked it so much that I enhanced it to the point that he might now be uncomfortable with the bells and [...]
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Tue, Feb 15 2011
  • Adding Functionality 3 — Where is the cursor?

    In addition to being able to sort the results of Dick Kusleika’s VBE Find I wanted the code to automagically fill in the search field. If there is a selection, the code should use that selection as long as it doesn’t span more than one line. If there is no selection, then the [...]
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Mon, Feb 14 2011
  • Adding Functionality - 2b

    In Adding Functionality - 2a I laid out the UI changes to support sorting of the results of Dick Kusleika’s VBE Find. In this post, I develop the actual sort routine. To recap, the task is to sort a 2D matrix on any number of columns. The sort columns are listed in a 1D array, with [...]
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Sat, Feb 12 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
Page 1 of 2 (16 items) 1 2 Next >
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.