Hi...Im back again.............I thought i'd sorted it then this one popped
up........
I'm doing the time sheets for work (still!).........to try and keep it
simple, I input peoples start and finish times into a cell, that data is

If Sheet1, A1>0, I want the contents of B1 to appear in the message
box.  The only button I need in the message box is OK.  Clicking on the
OK needs to do nothing more than to close the box.  Can anyone help
with this?  (I'm a novice at macros, so please be somewhat detailed.)

I'm accustomed to databases, in which this is easy. After browsing this
group, it appears that Excel cannot do this?
I have ranges on Sheet1, and data validation list boxes on Sheet2 pull
in the data from Sheet1.

I'm creating a tool that will be used by multiple users.  Although the
external data will be same, the users may save it differently.  I
thought I would use GetOpenFileName so that the user would select there
own file.  However, I don't know how to close the file once the data

I have a workbook that posts to two other workbooks. As part of the setup
process, all three files are in the same directory (wherever the user
initially saves them by downloading from our website or saving from email).  
About 140 locations will use these files, and each one can ...

I'm working on a worksheet that I update daily with new numbers.  A new row
daily.
Everytime I add a row I have to go back and update all my trends(formulas)
with correct reference numbers for the new line (such as the reference C7

I have a long looping macro I'd like the user to be able to exit by pressing
the Spacebar.  I'd like to accomplish this without the big overhead usually
associated with API calls.  Any simple (short) way to do this?  Probably a
wierd question!  But thanks and happy holidays!  ...

I need to have a macro that will take look at a cell ("A1") then divide
that by the number of worksheets.  So if I have 200 in cell A1 on
worksheet 3 it would be 200/3.  Then on worksheet 4 it would be 200/4
and so on.

Can anybody please help... i have the code below that changes the Shape
(Freeform 13) on a Chart2 tab, in Sheet1 in cell a9, is a value that
determines the colour of the shape.. and this works fine... the
question is, how do i modify this code so that i can add other shapes

I should know why this doesn't work...but
get 'Wrong number of arguments or invalid property assignment'
and can't resolve it.
With Worksheets("Stats").Range(p$)

I knowe that I can import a spreadsheet into Access to become a database.  At
my work we currently use numerous spreadsheets to track different types of
data.  I'd like to consolidate this into one area with one interface for ease
of use.  Is it possible to import several ...

I have tried making sense of the code from the Macro when I recorded it
but it isnt working for me.
   Range("Q6").Select
   ActiveCell.FormulaR1C1 = "=RC[-14]+'07-Dec-06'!RC"

Howdy. I am working with VB in Excel 2000, and am trying to call up a
User Form when something happens in my code (in VB).
However, when I am in VB, and go "Insert">"UserForm", and then open up
the UserForm, I can see the grey userform, I can change the properties

3 ways to make a simple operation (same)
My question : Why the result is not the same ? any explination ?
1 - )
X = Int(37.7266 * 10000)

I have only the Standard Excel toolbar open.  I have created a custom
toolbar which is attached to the file.  The custom toolbar is loaded when
the file is opened and deleted when the file is closed.  Problem is, my
custom toolbar keeps showing up above the Standard toolbar, and ...