jump to navigation

Creating a UserForm from an Excel Spreadsheet April 1, 2006

This is a work in progress, but it allows you to create a UserForm based on the cells in an Excel spreadsheet. The data can then be edited in the UserForm and copied back to the spreadsheet. The VBA code could use a few more features, but I thought I would post this as-is in case anybody wanted to pick it up from here. Please let me know if you improve on this.

File: userform-from-spreadsheet-2.xls

Creating a UserForm from an Excel Spreadsheet_image001.png

Creating UserForms Programmatically February 7, 2006

Creating UserForms Programmatically
and Handling Events with a User-Defined Class

This post contains an example Excel VBA file that demonstrates creating a UserForm programmatically and handling events with a user defined class. This is especially handy for creating forms with many similar controls. The file contains examples with Buttons, ComboBoxes, and TextBoxes. The figures below show the form with a button grid and the response of the event handler. Download the Excel file: UserFormProgEvents2.xls

ButtonGrid Event

Reference:
This is an extension of work found here:
http://www.j-walk.com/ss/excel/tips/tip44.htm

Dynamic Excel Chart Colors January 17, 2006

Did you ever want to have the colors of an Excel bar chart change dynamically with the values of the chart? The code below gives results like those shown below.

ColorChart

Just place this code (more…)