Worksheet A is saving every 5 seconds.  Worksheet B is refreshing links from
A every "x" seconds.  When these events occur concurrently, I get a pop-up
asking that I select the source file (A) that was not found during the macro.
If I cancel out, it yields a 1004 error.

I've been trying to validate the value of a textbox with partial success.  
The value input must be a number but it can also be a decimal number.  I am
trying to catch alpha characters but my Like statement is not catching it. I
have tried various versions, "A-Z", "a' - "z", a-z.

So I created a few macros that run on shortcut keys.  Somehow, I moved them
to a place where the shortcut keys aren't recognized.  I can still run the
macros via menu options, but don't have the "ctlr + button" control that I
used to.  Anyone else come across this issue?

For some years I have been using MS Access to manipulate data into a
required format and then displaying it using Pivot tablesin Excel .
The thorn in my side with this approach has always been union queries
which, except in certain circumstances, will throw an error (too many

I am looking for a way have a user paste (from excel) a list of values
into a form object, say a textbox, and then extract the data from that
textbox as a list. When I paste a list of values into a textbox
manually it leaves it all on one line and seperates the values with a

Hello Hello,
How do i make a textbox only visible if the label has a value in it. Example
might be in vba there are 10 labels and 10 textboxes. When i activate the
form and i have it only three labels fill with information i only want to see

I'm using a function that returns an array of data.  I put in the
function name and hit ctrl-shift_enter and every cell in my selection
gets a #VALUE.
So I thought the function might be returning bad data.  I put a

Hi all I need some help I have  sheet one that has like a questionair on it.
And then sheet two where I want it to display the results. The problem I have
got is when I fill the form in once it works fine. However when I do it again
it over rides the first entry so I need the ...

When the active cell doesn't have a Reference Name the "On Error GoTo
ExitMe" does not trigger but instead I get the runtime error 1004.
Could you please tell me what I am doing wrong? Thanks-
Private Sub CancelButton_Click()

Hi, on a sheet in the area M13:AA6000, i'd like a macro to replace all cells
that are empty or have a value of 0 with a calculated number.
For example, if in cell F500 it finds a value of 0, it calculates and pastes
as value in a new number which is the average of the two ...

I'm having problems with display alerts that I'm not sure is fixable.  I have
a macro that lets your choose a date from a form and then from that it takes
data from one workbook and copies it in to three other workbooks.  It then
saves, closes and emails them to certain ...

VBA form controls do not include a date-picker. VS2005 does. This is a
critical matter for me. Is there a way to import a VS2005 form in Excel VBA?
(I am trying to create better reports than Crystal, that will take data from
a database, based on user selections in a form, and then ...

I'm not sure I can do this.  I've been unable to figure out how, but I have
created a password form.  I need to use this form to unlock specific cells
and run code depending on the password being correct.  I am successful if
there is only one routine the password form is ...

I have a sheet tab that is named "MASTER".  I am trying to write a macro that
will copy this sheet tab multiple times based upon the value in cell A1 of a
sheet tab called "QTY".  For example, if the value on the QTY tab is "4", the
"MASTER" tab will be copied 4 times---always ...

I'm working with .CSV worksheet that arrives already 'Text to Colmuns....'
The data is delimited resulting in various data positioning.
Can someone help with macro that will
1) Find 'END CELL' In sheet given random placement of data