Daily posts of Excel tips…and other stuff
Archive for the ‘Application Object’ Category.
I’ve made my first iteration of a program to record my tasks (genesis here).
J-walk suggested:
Create a bunch of general work-oriented categories. Then, when the timer goes off, have XL display a Userform that lets you allocate the last hour by percent in each category. Even if you’re away from your desk when the timer goes [...]
I have two custom add-ins loaded that use application-level events. I only want those events to run when a workbook associated with my application is active. Otherwise, the events in my purchase order application will try and do stuff to my invoices and vice versa. Not good.
For every application, the first thing [...]
I tried to use EnableCancelKey to allow myself to stop the music and still make the appropriate API calls to reset the midi out. It didn't work so well for me. Here's another way.
I created two global variables. One to determine whether the procedure was already running and one to determine if [...]
The EnableCancelKey property of the Application object determines what will happen when a user interrupts your code. Users can interrupt code by pressing Esc or Cntl+Break. EnableCancelKey has three possible settings:
xlDisable - Prevents the user from interrupting. I've never used this and can't think of why I ever would.
xlInterrupt - Normal operation. [...]
Hi All,
If you do some VBA programming regularly, you'll be acquainted with the Object browser, which neatly shows you all objects, properties and methods belonging to any object in Excel (or any other library you have referenced in your VBA project).
Whilst this is a tremendous tool to look for information on just a couple of [...]
I learned some things today. Apparently I've never used Application.Caller in a procedure called from a custom CommandBarButton. Or if I have, and have since forgot about it. As it turns out, Application.Caller returns a Variant array with two elements. The first element seems like it should be the index number [...]
This article describes a bug recently discovered by Ron de Bruin and which has also
been reported here.
The Application.InputBox function is very useful to get a range from
the user. Unfortunately, this function exposes a bug in Excel (all current
versions!). If the sheet on which a (range of) cell(s) is selected contains
conditional formatting using the : "Formula [...]
I recently got a new (to me) PC at work. I went from 512 of RAM to 1G, which is quite nice. Anyway, I used the post and comments on Power User Setup to get Excel humming the way it was. One comment, by John Walkenbach, was that he unchecks the Move [...]
