Add-on For Excel Users

dave.m · Post by **dave.m** » Sat Mar 06, 2010 8:34 pm

I don't use Excel myself but came across this FREE add-on that does a lot of little extras for Excel:

http://www.asap-utilities.com/index.php

Thought it may be of interest to some of you.

dave

Post by **ultimatehandyman** » Sun Mar 07, 2010 10:20 am

I use excel to draw the monthly competition winners.

Hoovie made me a spreadsheet in excel for choosing the winners, he is brilliant with it and can make it do all sorts

wine~o · Post by **wine~o** » Sun Mar 07, 2010 10:33 am

ultimatehandyman wrote:I use excel to draw the monthly competition winners.

Hoovie made me a spreadsheet in excel for choosing the winners, he is brilliant with it and can make it do all sorts

Wow =IF( Icould do that, "Happy", "Sad")

I'm on a basic course which includes some Excel, but that must take some doing

DIY_Johnny · Post by **DIY_Johnny** » Sun Mar 07, 2010 11:28 am

Good think about excel is that anybody can try customise it with VBA. You don't have to be a trained programmer. just record a macro and you have a great starting point.

Creating a basic add-in is fairly straight forward

Try this for a first bit of VBA

1. Open Excel
2. Press ALT+F11
3. Type msgbox("Hello UHM") into the Intermediate Window and press enter (Tip:If you don't see this window, try VIEW->INTERMEDIATE WINDOW ). You can delete all the other stuff typed in that window if you want.

you have just don't you first bit of VBA