Page 1 of 1
Add-on For Excel Users
Posted: Sat Mar 06, 2010 8:34 pm
by dave.m
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
Posted: Sun Mar 07, 2010 10:20 am
by ultimatehandyman
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
Posted: Sun Mar 07, 2010 10:33 am
by wine~o
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
Posted: Sun Mar 07, 2010 11:28 am
by DIY_Johnny
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
