How to format a row of cells based on the string value of a reference cell.
Computer Stuff
Excel VBA: Replace Images (Shapes) Locked To Cells With Text
This is some code that will replace an image/shape that is locked to a cell with text.
Excel VBA – Create iCalendar file
This is some code to create an iCalendar (.ics) file from data in cells
Visual Basic: Right Align Long String In TextBox
This is a chunk of code to set the text of a text box to align right if it exceeds the length of the text box.
Using Excel Solver In VBA
Here is a routine that shows how to use Solver within VBA.
Convert Excel Named Range To Local Scope
Here is an Excel VBA routine for converting a named range from Workbook level scope to Worksheet level scope.
My vi Cheat Sheet
My condensed version of a cheat sheet for the vi editor.
Excel VBA – RGB to HSV Color Conversion
VBA function to convert RGB values into OpenCV HSV values.
Visual Basic/VBA – Working With Text Files
Here are a few methods for reading/writing text files.
Auto Create Excel Named Ranges
A macro for creating named ranges in a spreadsheet. The generated names are local in scope.
VBA Batch File Rename
A VBA sub routine for batch renaming/moving/copying of files.
Excel VBA Curve Fitting
These are some curve functions that can be used to generate curve fits to data that doesn’t lend itself to the built in Excel curve fits.
Site Update
I am updating my website. Please check back soon.