Tags » Vba

Convert integer to Excel column letters (and back) using VBA

So I mentioned previously that I have been working with VBA a lot lately.  I’m going to put some of the functions and subroutines that I constructed for my needs.   541 more words

Excel

Vienna Brown Ale

Many of my recent brews have explored styles that are new to me–saison, Bohemian pilsner, witbier, and altbier, to name a few. 455 more words

All-grain

Adding Hyperlinks to Salesforce IDs

We’ve all had the frustration of copying and pasting the Salesforce ID from a spreadsheet into the URL to view an object. Did you know there is a relatively quick and simple way to add the relevant hyperlink to all Salesforce IDs in a spreadsheet? 174 more words

Hyperlink

VBA Data Types

Data Type or Subtype Required Memory Default Value VBA Constant Range Byte 1 byte 0 vbByte 0 to 255 Integer 2 bytes 0 vbInteger 113 more words
VBA

Log file from Excel COM API program

It’s a good habit to track the data your process has changed. Most programs should have some type of logging mechanism. Sometimes in the haste to roll a tool out the door, simple tracking pieces are left off. 448 more words

API

What is the syntax to return the row of a search value?

<integer variable> = Application.WorksheetFunction.Match(<search value>, Range("<searched range index>"), <0 for exact match or 1 for approximate>)

Helpful tip: also use error handlers to catch 1004 errors (that arise from not finding a match for your search value) 52 more words

VBA

What is the syntax to get the date selected for a calendar?

  1. Add a calendar to your userform (for instructions, click here)
  2. As shown in the screenshot below, select your calendar control (default name is always MonthView1)
  3. 28 more words
VBA