I want to change the background color of the cell by using conditional formula.
like...
Cell A1's Background color should be
          Red, if B1>C1

I was use the code below mention in macro, in office2002 its working
fine, i have to run office2000 it was show error like : compile error
in hidden module: sheet1
kindly advice me what shall i want to do.

I have made up a spreadsheet that has 17 worksheets ,I need to copy data
from one worksheet to the next EG
Worksheet 1 column B cell 23 to worksheet 2 column B cell 2.
Can anyone please tell me what I need to write for the equation??

I want my userform to have labels that are updated with data from a sheet.  
Where do I put my code to change things on my form.  For example, if I want
to make a checkbox.visible to be false if sheet1.a1="yes" where do I put code
for this.

Hi - I want to develop a program to repeatedly copy a Workbook file
whilst it's opened by Excel (let's say it will do it every 10
seconds).
I've tried this out myself (doing the copies 'by hand' ) and there

I believe I am making this too complicated.
The Start Here list of items and counts the number of items in C9.
I want to use the number of items to determine how many columns I need
on the other page + a column between each.

I'm hoping to find a Win32 API which will provide me the memory size
of a safe array dimmed in VBA.
Here's what I am trying to solve...
I currently calculate a moving average of the last x elements stored

I'm testing random numbers for games using excel 07 generator, but there is
too much bias away from statistical expectation.  For example, when two
integer numbers are generated between 1 and 6, and subsequently added, the
results differ from the easily predictable numbers.  ...

I have a requirement where I need to graph data by seconds...Excels
graphing doesn't create a upward curve but as single vertical line.
Can the x axis not be a metric of seconds?

I'd like to set page break lines and print area in a worksheet using VBA, but
have no idea how to do this...
I have a worksheet with 11 pages (of the same size) when viewed in Page
Break Preview:

Some simple questions:
1. How can I change the size of the characters in a selectionbox?
2. How can I force somebody to fill in a date in a textbox? I can do
it with a cell but I couldn't manage it with a textbox. (If possible

I have the following code:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
       msg = "You are attempting to manually exit a DCA file." & vbCrLf &
vbCrLf

Two questions:
1) Is there a way to convert a number into text while keeping the
comma's? I know I can simply select cell/range and go to cell format
and select text to convert it, but it loses the commas. This leads

I have a program creating an array using Chip Pearsons excellent
UniqueRandomLongs function. I found some other code in here that will
put it in a worksheet in 1 column. This method seems to have a max of
256 items (# of columns in excel I suppose). I would like to be able

I can't figure out what is wrong with this line of code:
Image1.Picture = LoadPicture(sFileName)
This is in Excel 2000.
I get  "Compile Error: Sub or function not defined," and LoadPicture is