I just created my first Excel Worksheet that is anything more then a simple
list. This project is also among my first Excel projects. After creating, I
put it on our server in our shared documents file, which has beome a very
successful and unconfusing way for us to share our ...

Hi, does anyone know how to get the text that appears on a form control check
box? I can do it by using ActiveX control check box, but is there any way to
do it if I use the form control check box?
Thanks for your help

help

I've been switching from Quattro Pro 9 to Excel 2002, and I just saved
Quattro Pro file(.qpw) as an .xls file.  Then I moved it to my .xls folder
and opened it with Excel 2002.  Everything seems to be ok except that the
gridlines are missing.  I looked in the Excel ...

I have modified Gord Dibben's macro from a few days ago to color the
cells in the workbook that contain formulas.  However, after I do that
I want to return the cells to the original color.  I toyed with the
idea of creating an elaborate array to capture the original color and

Trying to get a value (held in a SINGLE variable) to be displayed in a
cell in a this format [h]:ss
But, when i do this
sngTime = 1       'for one day

I've got a survey tool that exports survey results as Excel. It puts
each question on a seperate worksheet tab. The export always has the
same naming scheme and structure everytime. I can't change the survey
export. So my tabs looks like:

C139 is a drop down with the numbers 0-4.  The user chooses a number and
then either a 1 or 0 is placed in the correct column.  At the end of the
sheet there is a count of how many 1's, 2's and so on.  There are 5 columns
(0-4) and a 1 is entered in the correct column depending ...

Exported contacts from Outlook 2003 in Excel format. Has vertical bars in cells (appears as box in "formula").  These represent "hard returns" from multi-line addresses. How can you remove?
Alice
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

My spreadsheet looks something like this:
I have 5 columns as shsown below
  A                B                  C              D              E
DATE        Insurance       Deposit       Rent          Total

Ok, Got to say Thank you for finely expanding the maximum number of cells
(row & columns ) that we can use.
For those that don't know it went from 65,536 X 256  To 1,048,576 X 16,384
So Once again Thank you for this expansion.

Tried everything suggested in the Help menu, honestly, but apparently I'm
not doing it correctly.
Would like to re-dock the upper toolbars with the main grid-cell screen.
They have apparently split asunder.

Need a formula for the following please:
Rate  4.95%
Upto 3,500 exempt ie; to $ 3,500
Maximum 43,500 - Maximum charge is $43,500

If you develop an Access application, you can hide your source code by
converting the .mdb file into an .mda file.
Is there an equivalent for Excel applications?
Thanks

The way I arrange my books record in Excel is have different categores
in different worksheet.
Information about each book is in one row. Sometimes one book may
belong to multipel categories. Is there a way to link the books from