Is it possible to create a checkbox that will mark a range TRUE or
FALSE depending on the condition of the checkbox?  I have a range of
cells i want to mark as true or false dependent on a checkbox in a
form.  If you link a checkbox to a range it will only change the first

Is there a way of going straight to the next value in a For / Next loop,
having tested the current value? I need to do something like this (for
example):
Dim c as Range

here are some problems I found recently and would like some answers
1) The help window in VBA doesn't close.  This started recently but cannot
get it closed unless I log off.  Don't know why
2) Can anything be done to stop Worksheet_Change from recusively being

I have a spreadsheet where users will enter account numbers in 10 specific
rows in a specific column.  They will only be able to enter certain accounts.
The accounts will be located on a hidden worksheet so the users won't see
them.

I have a couple of macros in my personal.xls that open when I open excel.  
However, there are reports that are brought in from another application and
opened with excel.  When the spreadsheet opens that way, these macros are not
available.

A decade ago, I last ran dlls from the VBA environment.  I'm tryin
again, and my day of reading, hacking and googling has yeilded only
failure for me.
When I use Application.Run, it appears that the executable dll is

I want to write a VBA (Excel) code to do the following...
Recognise when "Yes" is typed into any cell in column "C" on "sheet1"
and then cut that row, and paste it into the first empty row on
"sheet2", and finally delete the row on "sheet1".

Howdie,
I have a macro that loops through all the sheets and prints them -
however it prints them in the order they were created, not in the order
that they are displayed on the screen. How can I get Excel to print them

Could you please tell me how to paste from a single workbook to multiple
workbooks in the same folder. I need to copy 5 columns to the same sheet on
all the multiple workbooks. I need to copy it after column AN. I am new to
programming. Thank you in this regard.

I have a chart where I would like to either show or hide data labels for
individual points depending on the value of the points. Does anyone know of
ways of doing this?

How can I install an add-in using vba code.
Thank You,

HI! i JUST WANT TO ASK ON HOW TO VIEW DATA FROM A WORKSHEET TO THEIR
CORRESPONDING FIELDS IN THE USER FORM AND DELETE DATA FROM A WORKSHEET USING
FORM AFTER THE USER HAS BEEN ABLE TO FIND FOR A PARTICULAR DATA BY INPUTTING
AN ID NO.

I have a workbook containing several sheets; all with varied amounts of data.
What I would like to do is to create a dynamic summary page of all the
sheets in the workbook, where all the cells are live links to their original
locations.

i wasn't clear on one of my posts (not the one chip responded to--thx).
upon opening excel, i get this message:
'C:\Documents and Settings\mike\my files\test.xla' could not be found.
Check the spelling of the file name, and verify that the file location is

i've programmed a macro so that a pop up asks for the values that have
to be put into a cell
this already works : sheets1.cells(1,1) = inputbox("Give value for
cell", cells(1,1))