Visual Basics in Excel

[onyx4813]

I went to the website cpearson.com and got the information for the
syntax and the formula to sum numbers in different colors on a
worksheet
now my problem is where do i put the visual basic part of the works so
the formula can call on it
can you tell i have no idea but great hopes!!!
thanks everyone

 

[David McRitchie]

I expect you went to
http://www.cpearson.com/excel/SortByColor.htm

You would install the User Defined Function in a Standard Module
for more information on modules see
http://www.cpearson.com/excel/codemods.htm

For information on installing the code see
Getting Started with Macros and User Defined Functions
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Would suggest you install the Function(s) in your
personal.xls file.

 

[Bob Phillips]

Put it in a standard code module in the workbook. In the VB IDE (Alt-F11),
insert a new module (Insert>Module).

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Norman Jones]

Hi Onxy4813,

You may wish to visit David McRitchie's 'Getting Started With Macros And
User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm