I'm trying to create a form with checkboxes that utilize a "nested"
behavior.  For example, you can't mark the "Email Account" checkbox
until you have first marked the "Network Account" checkbox.  I see
where I can manipulate the checkbox object's "enabled" property, but

I have entered data into a sheet and just went back to it to find that
several rows are repeating over and over and the data I entered in row 8 on
contain the info from rows 1 - 7 over and over again. Can someone tell me
what I did?

With the help of Max and Bob Phillips here in this forum, I have been able
to use the Sumproduct function to produce values in a workbook.    Here is
the function as I have made it:
=SUMPRODUCT(--(SName="ANDA"),--(SType="BOND")*SAmount)

I've set up a default workbook according to the Help feature and what
I've read here.  As a result my new workbook opens when I start Excel,
when I insert a new worksheet and when I type cntrl N, however when I
click the 'new' button the only option available from the task pane is

I am a beginner with Excel VBA programming and would greatly appreciate any
advice on how to accomplish the following.
I created a user form with three text boxes (txtName, txtDescription,
txtProcess) and two command buttons (cmdAdd, cmdCancel).  I do not want the

I think I did all the right things to add an ADDIN but it does not show up
any where.
Here is what I did
Go to EXCEL option and select ADDIN

I would like blank cells in my spreadsheet to be white (no shading). I
would like the cells with text to be formatted to a selected color. I
did a search in this NG but couldn't find any similar situations. Does
anyone know how to do this?

I want to test to see if an adjacent cell is blank or not to change
the formatting of the cell in question. I would guess it might involve
the Offset property. Does anyone know how to do this?
Thanks!

I have a sheet where row 1 has names and the rest of the columns numbers.
for example
harry, bill, ann, kathy, and sparky
A program that I can not change pushes data into the spreadsheet.  I'd

I have the following formula in a cell:-
=IF($A$4="spring",DATEVALUE("31-12-06”),FALSE), which works fine.
However to make the formula more flexible, I don’t want to hard code the
year. Basically the year part should be current year minus 1 (i.e. 2007-1).

I have a spreadsheet with 3 columns of figures.  There is a price increase of
6% this year but I don't know how to use the existing spreadsheet and add the
6% to all 3 columns.

Hi - I am a noob to Excel.   I downloaded the checkbook register from the
Excel website figuring it would be an easy way for me to become familiar
with the program.  Here's what I downloaded:
http://office.microsoft.com/en-us/templates/TC101909831033.aspx?pid=CT101438521033

How do i unhide worksheet tabs in MSExcel 2007?

Hi,
I am new to Excel and VBA, I am looking for a keyboard shortcut to select
all worksheets in an excel workbook.
(Infact, i am planning to select all worksheets using a keeyboard shortcut

Hi- I have a list of dates in a column that I want to sort by- the problem
is that it sorts it in a way that makes no sense to me- is there a way to
sort by year/month in ascending manner?
Thanks