Can anyone point me to a code snippet I could use to run a macro every time
the print screen key is pushed (after allowing the normal printscreen
function of capturing whatever is onscreen as an image)? Basically I want to
automate pasting the new image and doing some other stuff ...

Is there a way of changing the default folder that VBA uses when I try
to import/export vba modules or userforms?  It seems to always default
to the MSO install folder.
I found a couple posts asking about this, but no answers.

Does anyone know how the set the print quality in Excel using VC++ ?
I know in VB, it can set the PrintQuality directly. But in the VC++'s
PageSetup class, it just have one method which prototype is
VARIANT PrintQuality(const VARIANT& Index);

I'm preparing a User Form containing List Box that shall be filled with
items taken from another excel file. My macro checks first, if this
source xls file is opened, and if not, it is being opened. However, I
realised, that filling the list box works only when the source file is

I have an Excel List created. When users start using it they often add
filters here and there and have a hard time remembering which ones they
had on and off to reset them back to the normal, unfiltered view.
Is there a way I can attach some code to a button that resets all the

I need to capture the number from a cell that contains data in the
format "2.45 Days" or "3.6 Days".  Is it possible to somehow remove the
"Days" elements and capture all else?  I am doing this programatically
using VBA.  

My problem is  pretty simple:
I want to create several pie charts from rows of data (1 chart
worksheet per row of data).
I know how to do this for 1 chart, but how can I pass in a range to a

I am trying to use Dynamic Data Validation inserted at run time but it fails
consistantly with :  Method 'Add' of Object 'Validation' failed.
The most basic snippet I tried was:
-------------------------------------------

About a week ago I posted a request for help on Hiding Unused Rows.
There was no response to this. I am wondering if there is something
wrong with the way I posted this. I found the solution myself but there
may be other solutions.

With the help of the good people on this group I've been able to create
about 8 macros for my company.  However, now I'm being asked to create
a macro that is way out of my league.  Maybe this task is too big for a
macro.  I have the following columns in my spreadsheet:

If have simplified a problem I stated earlier:
If B1=1, delete the contents of A1.  If B1 changes to any other value,
I do not want the former contents of A1 to return.  Instead, I want to
be able to manually enter new contents, knowing that as often as B1

I have created a userform with several textbox's on. They pull in
infomaton form a cell on a spreadsheet and i  then can edit them if i
wish to do so.
How can i format the text box's to show 2 decimal placings and

In an Excel2002 worksheet Col B is populated daily with 50-80 rows of
web page data all B cells with hyperlinks.
eg.
"http://www.mzmz.com/az/az_detail.php?save=1&id=158890PHPSESSID=andlotsoftrash789"

Devising a macro that needs to add all the numbers up together in a
given range of cells i.e Range(ref1 &":"& ref2) and assign the total to
a given variable i.e total.  Please let me know how I can do this.
I've tried to record a macro and copy details but that shows absolute

Hi, I have a spreadsheet with 2 tabs, named 'Summary' and 'Data'.  The
data tab contains information on web enquiries, this includes Date, and
Enquiry Type.
On the summary tab, I am trying to create a formula which simply