Visual Basics in Excel

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

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)


"onyx4813" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> onyx4813
> ------------------------------------------------------------------------
> onyx4813's Profile:
http://www.excelforum.com/member.php...o&userid=26305
> View this thread: http://www.excelforum.com/showthread...hreadid=396205
>

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"onyx4813" <[email protected]> wrote
> 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
>
>
> --
> onyx4813
> ------------------------------------------------------------------------
> onyx4813's Profile: http://www.excelforum.com/member.php...o&userid=26305
> View this thread: http://www.excelforum.com/showthread...hreadid=396205
>

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


---
Regards,
Norman



"onyx4813" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> onyx4813
> ------------------------------------------------------------------------
> onyx4813's Profile:
> http://www.excelforum.com/member.php...o&userid=26305
> View this thread: http://www.excelforum.com/showthread...hreadid=396205
>