Format Functions Excel Add-in!

[Zack Barresse]

VBAX has always been graced by such giving members. Well one of our members in particular is no exception. Graham Paramore, aka parry, has developed an Excel Add-in of some very useful functions that he wrote. He has graciously given VBAX permission to host this add-in for him and let everyone download it for free!

It is located on our Cool Tools (http://www.vbaexpress.com/cooltools.php) page. The add-in comes complete with it's own Help files and 15 Format functions, which are available for view (after installation - excluding help file) via the Function Wizard (Insert | Function | Format Functions), including but not limited to: FONTCOLOR, ISBOLD, ISITALIC, ISLOCKED, ISMERGED, ISUPPER, FONTSIZE, ISWRAP, NUMBERFORMAT, etc. These can be used as regular functions or even in an array formula!

I'd like to extend a very special thank you to Graham for sharing such a wonderful piece of work with VBAX! Thank you!!! I hope everyone can reap the benefits of this add-in; it certainly has made my work-load much less. :yes

Moderator Edit: No longer available.

[CCkfm2000]

thanks will check it out...:thumb

[Daxton A.]

Thank you so much Parry. It will be used tremendously.

Daxton

[Daxton A.]

Thank you so much Parry. It will be used tremendously.

Daxton

Just letting you know that I have not used it yet but it was tremendous work

[Jacob Hilderbrand]

Sounds pretty good. Thanks for all the hard work. I will definitely check this out.

[Digita]

Thanks Graham for such a useful add-in.

[r_mundhra]

Great Work Parry
Thanx V M . I checked it out...but any of the help connected to any of the function is not working.
I mean help files are not working...wld hv been gr8 with help file assistance

Rajesh:think:

[artds]

Hi there! I'm using firefox browser for my default browsing tool. When i tried clicking on the link for parrys excels add-in tools, got a bad link.


pls advice:dunno. Thanks
regards
artds

[Bob Phillips]

Try this link http://vbaexpress.com/members/formatfunc.zip

[artds]

Thanks xld! The tool's great!
however, i got a question. If i sent the xls file that i'm working on via e-mail to another person, without sending the xla add-in, Will the function still work.

I'm working on a project right now and this add-in, i'm sure will be used quite extensively, just wondering though.

Anyways... this page will definately be revisited over n over again, so thank you all in advance for all the help soon to be rendered.

regards
artds

[Zack Barresse]

Sorry, didn't see this right away. I updated this a few weeks ago and missed the correct case spelling. The link is now fixed and working. :)

[Bob Phillips]

Thanks xld! The tool's great!
however, i got a question. If i sent the xls file that i'm working on via e-mail to another person, without sending the xla add-in, Will the function still work.

No, they will need the addin.

[winxmun]

Tks Graham! I just managed to install the Add-in function & yet to try it. I believed it will be very useful in my work. Thank You!!!:friends: :thumb :mbounce2:

[Matticos]

Great Wrork:clap:

[nst1107]

help files are not working
That is true. The help files did not work on my computer with Vista. But the rest of the add-in is A+. Good job.

[PSL]

I would have called it brilliant.
But that would be an understatement.

Regards,

[anthony20069]

what is the password for this?

[jocote46]

I couldn't find it!

[mbarron]

It's the third Cool Tool listed. Here is a direct link to the ZIP file (current as of April 17, 2010). Parry's Format Function Add-In (http://vbaexpress.com/members/formatfunc.zip)

[jocote46]

Thank you so much!