Browse by Tags

My Coding Technique

Dick has been kind enough to allow me to mirror posts from DDoE, but gets little back. Therefore as a guest poster I thought I would post some ramblings I made today on excel user group regarding my own particular coding techniques. (It also allows him the weekend off) I have recently been doing most of [...] Read More...

Published Fri, Aug 08 2008 5:11 PM by Daily Dose of Excel

Filed under: VBA

Identify Empty Cells in VBA

Whenever I need to determine if a cell is blank, I call the IsEmpty function on the Value property. If IsEmpty(ActiveCell.Value) Then This anonymous blogger uses vbNullString. If ActiveCell.Value = vbNullString In other news: In Firefox, Cntl+Click on a hyperlink and it will open that link in a new tab. Except for the aforementioned blog's heading. [...] Read More...

Published Thu, Jun 06 2008 10:01 AM by Daily Dose of Excel

Filed under: VBA

Create a QueryTable from an Excel Source in VBA

Elton is trying to create a QueryTable based on a named range in a closed Excel file. When the code tries to refresh the QueryTable object, he gets an SQL Syntax Error message. Although he's sure his SQL syntax is correct, it's almost certainly not. The syntax you get from the macro [...] Read More...

Published Tue, Jun 06 2008 9:03 PM by Daily Dose of Excel

Filed under: VBA, External Data

On-the-fly data entry form

Hi all, So after Dicks (nice to read) rambling on golf, let’s do some Excel/VBA stuff again. I intend to get a bit of discussion on this one, so bear with me. I’m currently developing an Excel workbook for a customer. One of the interesting things with this project is that it consists of multiple data tables, each [...] Read More...

Published Wed, Jun 06 2008 6:46 AM by Daily Dose of Excel

Filed under: VBA Advanced, VBA, MVP, Userforms and Controls

Fixing Links To UDF’s in Addins

Hi All, Excel has a host of built-in functions to help you do your computations. But sometimes you need to write your own functions using VBA. These functions are called “User Defined Functions” (UDF). UDF’s typically are placed in addins. As long as the addin is installed, the UDF’s work as expected. You get into trouble [...] Read More...

Published Mon, Jun 06 2008 1:45 PM by Daily Dose of Excel

Filed under: VBA, MVP, Downloads, Add-ins, User Defined Functions

Recording Macros

There’s an interesting discussion at Smurf about the macro recorder. I rarely use it, but I used to use it quite often. I actually just used it last week for something to do with FormatConditions, but I don’t remember the details. Intellisense or the Object Browser usually gets me where I want [...] Read More...

Published Thu, May 05 2008 2:11 PM by Daily Dose of Excel

Filed under: VBA

Showing An Array On A Form; Autosizing ColumnWidths Of A ListBox

Hi all, For a project I needed a quick way to display the content of an array to the user. I didn’t want to use a worksheet, but opted for a userform. The data I wanted to show was contained in an array. The array contained something like: Description Before After Cell Errors 100 10 Corrupt Names 1000 0 Unused styles 232 0 So I figured I’d put a [...] Read More...

Published Wed, May 05 2008 1:39 PM by Daily Dose of Excel

Filed under: VBA Advanced, VBA, MVP, Downloads, User Interface, Userforms and Controls

Is VBA Recovering?

I previously mentioned that VBA is dying. At least one of my arguments was that MS couldn’t be bothered to port it to the new MAC architecture. Now c-net says: Finally, the company announced that, for the next full release of Office for Mac, it is bringing back support for Visual Basic scripts. That [...] Read More...

Published Tue, May 05 2008 12:11 PM by Daily Dose of Excel

Filed under: VBA

Using a Class Property to do more than just Assign or Query a Value

The purpose of this article is to introduce various capabilities of a class property. It is not meant to serve as an introduction to classes and objects. See the references section for introductory pages. The typical use of a Class Property is to assign a value or to query its value as in the [...] Read More...

Published Fri, May 05 2008 12:03 AM by Daily Dose of Excel

Filed under: Classes, VBA, VBA Basics

VBE Bookmark add-in for Office 2000-2007

Hi all New page on my site with a very useful add-in from Jim Rech. http://www.rondebruin.nl/vbebookmarks.htm VBEBookmarks.dll is a simple COM Add-in created by Jim Rech for the Microsoft Office 2000-2007 Visual Basic Editor which lets you bookmark up to five locations in VBA projects for easy navigation among them. Have fun Ron de Bruin http://www.rondebruin.nl/tips.htm Read More...

Published Mon, Apr 04 2008 3:44 PM by Daily Dose of Excel

Filed under: General, VBA, Downloads

Random Sorts

Red wants to have a kind-of lottery for his students. He will award them prizes based on a random drawing, but wants to weight each student based on the number of assignments turned in. Normally, I would accomplish this by typing the name of each student in column A one time for every [...] Read More...

Published Sun, Mar 03 2008 10:54 PM by Daily Dose of Excel

Filed under: VBA, VBA Basics, List and Table Functions

Rows and Columns

gullible.info sez: An average Microsoft Excel spreadsheet document has 1,102 rows and 18.2 columns. I say: That's 470 rows and 25 columns. I had 408 sheets whose last cell was A1, i.e. blank. I attribute that to two things: I probably have quite a few workbooks that are just code; Most of the workbooks I get [...] Read More...

Published Thu, Jan 01 2008 9:50 AM by Daily Dose of Excel

Filed under: VBA Advanced, VBA

Hash and Stack in VBA

These are a couple of links that I want to keep handy. They describe creating a stack and a hash table in VBA. Hash and Stack VBA Modules Hash and Stack in VBA for centralised configuration and error handling Read More...

Published Fri, Jan 01 2008 9:31 AM by Daily Dose of Excel

Filed under: Links, VBA

Catching Paste Operations

You know the situation: You have carefully setup a workbook with intricate Validation schemes. But then along comes your user and he copies and pastes at will. Result: Validation zapped, workbook structure violated. What to do? The only way I find to be reliable is to catch all possible paste operations. But this isn't very easy, [...]

Published Mon, Dec 12 2007 2:27 PM by Daily Dose of Excel

Filed under: Classes, CommandBars, Collections, Copy and Paste, VBA, MVP, Events, Data Validation, Downloads

VBA Code Documenting Tools: Project Analyzer and Visustin

Every VBA developer (which is anyone who knows how to get into the VBE I guess) develops his or her own programming habits: sparse commenting or elaborate commenting, naming convention (or no declaration at all), code indenting, preference for certain structures and methods over others. You name it. Many books have been written about this, [...]

Published Thu, Dec 12 2007 3:58 AM by Daily Dose of Excel

Filed under: VBA Advanced, VBA, MVP

Syndication

Recent Posts

Tags

News

Archives

My Coding Technique

Identify Empty Cells in VBA

Create a QueryTable from an Excel Source in VBA

On-the-fly data entry form

Fixing Links To UDF’s in Addins

Recording Macros

Showing An Array On A Form; Autosizing ColumnWidths Of A ListBox

Is VBA Recovering?

Using a Class Property to do more than just Assign or Query a Value

VBE Bookmark add-in for Office 2000-2007

Random Sorts

Rows and Columns

Hash and Stack in VBA

Catching Paste Operations

VBA Code Documenting Tools: Project Analyzer and Visustin