I have a timecard which has data and a layout looking like the
following (timecard is on a sheet called "Time Card" and the log sheet
is called "Log"... the dates are formula-generated):
Employee Name [cell C9]

I am really running this past people before I start writing code to
ensure I can actually do this one way or another.
I am wanting to write a macro in a sheet that finds a certain cell in
every excel file in a folder and sums them up. Sounds simple but am I

Sorry, but I did not realise there was a live thread with the same title
'Command Button' which is where my original request ended.
I would like to create a dual task command button that would stop some
code running and clear data on another worksheet.  Or would it be best

I have to insert a Static Date and Time in a Cell thru a Macro.
I know the key strokes for this function.
Current date   Select a cell and press CTRL+;
Current time   Select a cell and press CTRL+SHIFT+;

I would like to create a dual task command button that would stop some
code running and clear data on another worksheet.  Or would it be best
to keep these operations separate?
Clearing the data could be done with a macro assigned to the command

this property or method. Message I'm getting when I enter any text
password into the text box which uses this code:
Private Sub cbOK_Click()
sPwrd = ufPwrdEntry.tbPwrdEntry.Value <---Object doesn't support...

I have a plan with hours
A               B              C                   D         |
E              F
Enter         Lunch/In    Lunch/Out      Out        |      Oper1

Does anybody know if there is a way to determine how much data is one
individual sheets in a workbook?
Something along these lines?
Sub CountWS()

Have a workbook with 2 sheets--one named "Fields" containing formatted
columns, rows, etc., and another called "Data" containing the data.  I
would like the following functionality when adding a new record in Data
(one record consists of 4 rows):

I have a macro to cut and paste the entire row if the cell D is blank.
But I am facing an issue as its not stopping untill I press Esc button.
I need it to stop once it finish checking the last row which contain
data.

Guys,
I'm tearing my hair out over this one - I just can't see what I'm doing
wrong.
I'm trying to alter the PageSetup properties in a Workbook_BeforePrint

Actually, i have made a very complex worksheet and i don't want to
apply any formula over the worksheet cells.
Therefore, i need to apply cell format on the worksheet in such a
manner that it shows desired cells values in thousands.

I'm new to VBA and I am having trouble with a combobox.
Im trying to get a list from an excel sheet come up in the combo box,
but the list is in another workbook.
ive named the list "Reps" and if i enter Reps into the RowSource

in my latest project, I have to create bar-charts using the
ChartWizard-Method in Excel VBA.
The problem is:
I add the data ranges for the chart in a certain order to the "main"

In Book1 I run macro1 with the following code:
   Set objExcel = CreateObject("Excel.Application")
   objExcel.Visible = False
   objExcel.DisplayAlerts = False