SamT
01-02-2010, 02:45 PM
A little backgropund first. While recovering from cancer, I planned on starting a business and learned Excel as I knew a spreadsheet would be indispensable. That in turn led me to VBA and VBA Express about three years ago.
I want to take this opportunity to thank all of you regulars for putting up with my inane suggestions with such aplomb and curtesy, and for all the information you have made available.
During my VBA phase, I created a complete object model style help system in an Excel WorkBook that I would like to share as a partial payback to the community, however it is Excel 7 specific, so I am not sure it is still appropriate. It contains every word of all installed available help sources and follows Excels Object model layout, but presented on Worksheets.
Creating the system required a bit of work with Colors and I wound up writing a short procedure to convert names and RGB values to VBA values.
It works by having a Constant name, (Pale_Goldenrod,) in col A, an RGB value in B and outputs a pastable string like "Const Pale_Goldenrod As Long = 11200750" in C allowing "Pale_Goldenrod" to be used as a Color Constant in Code.
When I was setting up my Excel based accounting system, I had to define eleventy seven Names for each WorkSheet, so I wrote a little interactive Form based utility that scans selected rows or columns and creates Sheet specific Named Ranges. For example; The Name "sheet1!Label_One" is set equal to the Range D3 to D7 as long as Label_One is in Column D.
This could be handy for any coder that has to work with many Sheet specific Names.
Moderators,
Would you be intersted in these?
SamT
I want to take this opportunity to thank all of you regulars for putting up with my inane suggestions with such aplomb and curtesy, and for all the information you have made available.
During my VBA phase, I created a complete object model style help system in an Excel WorkBook that I would like to share as a partial payback to the community, however it is Excel 7 specific, so I am not sure it is still appropriate. It contains every word of all installed available help sources and follows Excels Object model layout, but presented on Worksheets.
Creating the system required a bit of work with Colors and I wound up writing a short procedure to convert names and RGB values to VBA values.
It works by having a Constant name, (Pale_Goldenrod,) in col A, an RGB value in B and outputs a pastable string like "Const Pale_Goldenrod As Long = 11200750" in C allowing "Pale_Goldenrod" to be used as a Color Constant in Code.
When I was setting up my Excel based accounting system, I had to define eleventy seven Names for each WorkSheet, so I wrote a little interactive Form based utility that scans selected rows or columns and creates Sheet specific Named Ranges. For example; The Name "sheet1!Label_One" is set equal to the Range D3 to D7 as long as Label_One is in Column D.
This could be handy for any coder that has to work with many Sheet specific Names.
Moderators,
Would you be intersted in these?
SamT