PDA

View Full Version : Things from Office/VBA that you hadn't realised...but should have?



crazyfray
11-10-2007, 06:09 AM
I'm thinking about things that make you kick yourself when you find out.

1 - Spent 3 hours doing forms for a set of excel apps - I've been putting it off for days (find that bit boring when I have a bit of meaty code to fight with :giggle), and finally get round to it. I've spent a lot of this time setting up checkboxes and labels to describe them. I'm about halfway through when I realise that checkboxes have their own captions, and if I'd dragged the checkbox area out horizontally I wouldn't have needed to align them all up or make sure they had matching names... :banghead:



NB: This actually might have a side effect of being useful, but I'm mainly curious.

XLGibbs
11-11-2007, 09:36 AM
Immediate window, debug.print, and locals window.

Bob Phillips
11-11-2007, 09:50 AM
Ctrl-F9 in the VBIDE.

OTWarrior
11-12-2007, 06:57 AM
being able to password protect the vb code in a word document without the document being protected elsewhere.

Tommy
11-12-2007, 09:53 AM
Shift-F8 in the VBIDE

malik641
11-13-2007, 10:54 PM
Enter an AutoFill-style formula in A1. Select A1-A10. F2, CTRL+Enter for autofill :)

shades
11-16-2007, 10:43 AM
Double click the lower right corner of a cell to autofill the length of the adjoining range.

malik641
11-16-2007, 11:02 AM
Double click the lower right corner of a cell to autofill the length of the adjoining range.
Now THAT is cool :yes thanks Rich!

Zack Barresse
11-21-2007, 04:55 PM
In the Worksheet:
Alt + =
Ctrl + F3
Alt + 1
Ctrl + 1
Ctrl + Shift + {1, 2, 3, 4, 5} (yes, five combo's)

In the VBIDE:
Alt + D, L - often! lol
Ctrl + R
Ctrl + G
Ctrl + H (most used!)
Shift + F2