I am using a combo box to select data that will update a field on several
pivot tables to keep them synconized. ie one tabel is Month and the other is
Year data. What happened is I have history in the Year data for an item and
no data in the Month data. How can I return data in ...

I am in the very early stages of learning programming.  Any help would be
greatly appreciated.
I am attempting to pull data from cells on another sheet, by using matching
reference numbers.

I have a workbook that opens a file, imports data and closes it down again.
The problem I have or will have:
The file that holds the data will change the name by having a date added, so
this will now mean I will have to manualy open the file and minus off the

Hi, I'm having difficulty filtering a list using auto filter as th
entire list is filtered out even though I know that the dates selecte
are in the list. Could this be a formatting issue?
Firstly, I'm using the calendar control in a user form to obtain th

Hey all.
I am working on a log-like mechanism in VBA. I programmed the following
sub:
Sub CreateLog()

I have my program set to save and close the ative workbook but i need to be
able to close out excel completely.  What is the code for doing so?
Thanks
Tim

Using Option Explicit gives me the compile error: Variable not defined, on
this code.  What would the correction be?
Sub OpenCalendar()
   frmCalendar.Show

I have tried to create a macro that will copy and paste information between
two woorkbooks. One of these always has the same file name (and is a read
only template) where as the other will vary as it is used by different
individuals.

Code:
--------------------
 Private Sub CommandButton1_Click()
 Dim value, acCell As String

Hi guys,
I believe that I have a bug in my macro. A certain cell in my
spreadsheet gets the value -4127 everytime I run the macro..
However there is nothing in the macro which says that it should print

hi
i have a sheet populated from a dbf(foxPro) file
and my first row contains field names
on the bais of that i want to refer entire column by relative field name

hi
I have a userform which has  labels,comboboxes, textboxes and
commandbutton.
I have 10 textboxes which are names from textbox1 through to textbox10

I'm trying to rename a workbook, so that I can select it later on in the
macro as I move between different workbooks. I do not want to save it though
as I do not want to keep the file and it will also take up time
I've tried a simple

I have a cell that is being calculated via VB, and it's not actually
calculating anything, just showing the formula. If i manually type in the
formula, the same thing happens. Is there some setting/format that i'm
missing? here's the code:

I am trying to create a macro that will save a copy of a file as an archive,
using the filename and year as eg(06). It then needs to delete all worksheet
links. The workbook contains three sheets called priority , bud, and eval and
these have links to other workbooks that I want ...