=IF(D5="Cash","Cash",IF(AND(OR($D5="Discover",D5="MASTER",D5="Master
card",D5="VISA"),OR(NOT((K5="SCA/FACS NONCARILION")),NOT((K5="SCA/NORTH
CAROLINA")))),"VMD",IF(AND(D5="null",OR(K5="SCA/FACS
NONCARILION",K5="SCA/NORTH

I placed a command button on my User form.  How can I assign my print_Invoice
macro to this button?  Or is there an easier way
I tried right click but cant see the option when in Vb mode
Thanks for help

HYCH with this
I have 7 buttons on a page but would like 1 to be displayed depending
on a given criteria, ie day of the week.
I was hoping the simple code below would work, but appears not.

I have an Excel spreedsheet that has many tabs that contain various financial
figures - these are automatically imported into the last 3 tabs that creates
a financial 'report' (the total number of pages from these last 3 tabs are
around 100 pages). How do I transfer the ...

I updated an Excel 2003 spreadsheet with new data and saved it to a CD about
3 weeks ago.  At that time, I checked the CD to make sure the file was saved
properly.  I was able to open the spreadsheet from the CD after I saved it
without any problems.  However, I just tried ...

Frequently I need to find out:
Present Value
Future Value
Discounted Value

I have a file where I want to use conditional format to tell whether this
student qualified for awards or not. Here is the example:
A                              B                          C                  
                     D

We have massive amounts of information from multiple sources of workbooks
that we need to update constantly on our Excel reports. To make things flow
faster, I set up vlookup, hlookup, with if(isna...) statements.
Unfortunately, my boss and her bosses did not find it intuitive ...

My question is similar to the one posted by Sassy on 6/14/07 (sorry I forgot
to check which discussion group I was looking at...)
I want to find out, in the same column, the numbers that are greater than 0
but less than 8

If one keys in his birthday, how can Excel calcuate his age based on:
- age today
- age next birthday
- age nearest birthday

I need to track time between products and phases.  Initially, I had this, and
it gave me the correct information:  A$3 references the 'label' ALPHA1 on the
current sheet, that I am getting the total hours from on the Details sheet:
=SUMIF(Details!$G12:$G2000,A$3,Details!$E12 ...

I have created a Sales Inventory Spreadsheet to help me as I pu
projects together that has entry fields for part number, vendor
descripiton, quantity, cost and sale price. In addition I have thre
columns with formulas for Extended Cost, Extended Sale and Profi

When you create a file name under "Save As", is it possible (through a macro)
at the same time to automatically create a hyperlink to that "file name and
path"  in a specific cell?

First how do I make a calendar. Second, how do I  put lines in  each box date
as space holders.
For example imagine like for example today.
Sept 25

I am trying to asking Excel to count up a list of things for me.
I often start at 1 and end at 89.
Yet sometimes is messes up the count. Sometimes even the bar to left count
is also wrong what is happening. How do I make sure that I get a perfect