Excel help/tutorials?

Man of Honour
Joined
11 Mar 2004
Posts
76,637
I'm going to be stuck in the office for 3+ weeks, with not a lot to do.
But they could do with a spreadsheets or two, but it's been ages since I used excel, so will need some tutorial/helps to get me going on some of the more "advanced" features. The two main things are, which I have no idea how to do are:
tick/check boxes and linking them, so if one is selected all the other are deselected.

and a macro to work out how many lengths can be made out of a larger length.
Say you have 130, would need to find out how many times 92 and how many times 19 would fit into that and what the left over would be (so would be 1x92, 2x19 and 10 left over. Or even better if I could put ranges in say 91.0-93.5 and 18.2-19.0 (although not essential)

So anyone know any good tutorial websites for such things or could point me in the right direction.
 
I've been looking for Excel tutorials etc of late and I found a thread on OcUK a few weeks ago that had a mention of MrExcel.com. I've not had a chance to actually use it but it could help you out. :)
 
My goto site for help with excel when i get stuck (not often these days thanks to help from sites like these) is http://www.cpearson.com/excel/topic.aspx

MrExcel is pretty good too. http://www.mrexcel.com/articles.shtml

I would avoid the microsoft site. My experience is the language used is pretty dense.

There are a LOT of good quality excel help sites out there. The easiest way to find them is to get stuck on a problem, then describe your program to the google, and read the results. You'll soon discover sites that you keep returning to with help at a level that suits you, and can bypass google in future.
 
Anyone know the vba code to update a chwckbox?

Checkbox1_click()
if checkbox1. Value = true then [update checkbox2. Value =false]

hopfully you get what i mean
 
What you've got there is practically it:

Checkbox1_click()
if checkbox1.Value = true then checkbox2.Value = false

OR
if checkbox1.Value = true then
checkbox2.Value = false
end if

If it's not working, check the names of the checkboxes.

Oh hang on - is this checkbox ona form you've created, or placed directly on a spreadsheet?
If on a spreadsheet, there are two different kinds of checkboxes, ActiveX and Forms, each of which have different syntax.

For ActiveX Checkboxes (the ones on the Visual Basic toolbar), syntax is as above.
For the ones on the Forms Toolbar you need to link them to a cell. Bear with me, this is a little tricky:
Such checkboxes have a cell link property, so you might link checkbox1 to cell A1. When the checkbox is ticked, A1 will be true, and if not, a1 will be false.
Then in A2 have a formula like "= NOT A1" (or "=IF(A1=True,False,True)")
Then have checkbox2's celllink property linked to A2, and there you have it.

Hope that helps!
 
More excel help sites:
http://www.mvps.org/links.html#Excel
That's an index to the sites of Excel MVPs.

Of those the ones I've used most are
John Walkenbach http://spreadsheetpage.com
Stephen Bullen http://www.oaltd.co.uk
Dick Kusleika http://www.dailydoseofexcel.com/
and Chip Pearson http://www.cpearson.com

Among the others, I have found useful addins and help on specific problems from
Alan Beban http://home.pacbell.net/beban
Rob Bovey http://www.appspro.com
Debra Dalgleish http://www.contextures.com/tiptech.html
Ron de Bruin http://www.rondebruin.nl
Tushar Mehta http://www.tushar-mehta.com
Jon Peltier http://www.peltiertech.com/
Jan Karel Pieterse http://www.jkp-ads.com
Ken Puls http://www.excelguru.ca
 
Back
Top Bottom