Hi;
I have an excel spreadsheet that if you click Anywhere in Column A it
will bring up a Calendar wheree you need to enter a date. I need the
Current date inputed in Column A and the New Date that you selected in

I have in sheet A, all the quotation about Parts. Which consist of fields
Part Number, description, unit price, Qty Offer, Remark (5 Fields).
then i would like to to display that quotation in Sheet B if i am entering
certain requested Part Number (the entry will be at A1)

I'm trying to retrieve data from two identical tables (different name and
data but same structure) into a Excel sheet.
I'm trying something like
"SELECT DISTINCT LIN07.COCLI, LIN07.DATA, LIN07.CODIART, LIN07.DESCRIPCIO,

I've been using this neat new code given to me last week for "protecting" a
sheet yet allowing vb functions to work:
*****************************************************************************************************
   With ActiveSheet

I have entered the required informationin the footer via VBA to print every
time, without having to go into Custom Footer and manually enter the
necessary. I do it this way to ensure multi users do not over write the file
path info.

This is shameless I know, but I'm stuck with my daughter's homework
question. Here's the question -
"Nine eggs numbered 1 to 9. Put the nine eggs into three baskets. The total
of the numbers on the eggs in each basket must be the same. How many

I am trying to check a cell to see if it's a C.  The example below is a sub
that is called from a Do Loop.  The line checkcellA = Worksheets .... is
causing problems.  Is it because of the variable counter??
Sub sub1()

I am working on a survey
I have a total of 22 questions in 5 groups. Each question can have
only 1 of 5 possible answers. The answers have a value attached such
as:

I want to pull data from SQL server by Excel using vba and ado
connection.
I have created a inputbox to get to parameter from user and pass the
input data to SQL

In a user form I have two combo boxes that contain dependant data.  When one
box is changed, the other box gives a list that changes based on the others
selection.  
I have the data entered on the form to populate a cell on xyz_change().  

Hi! I have a long list with names of banks. I also have three different
numbers (between 1 and 10) for every bank. Eg Bank A 5 7 4, Bank B 5 9 3.
Sometimes there are not three numbers for a bank but only one or two. There
are never more than three numbers though. I want to have a ...

I'm currently having an issue dealing with number/date formatting in
Excel.  I have a C# winforms application which uses a third party
component (GemBox) to open and read Excel files without having to
instantiate Excel.

Is there an easy way to create a list of all non-working days (Sat & Sun,
major holidays) between now and the year 2020?  I want to use this range as
the "holidays" argument in the NETWORKDAYS function.
I could create this list by hand, but if it can be done with programming,

Is there a way to control multiple listboxes via just one forms
Scrollbar? The number of rows in all the listboxes is the same.
I appreciate all your help
Thanks

In Excel 2003,
I was wonder if it was possible to make a custom toolbar to only open in one
file.
Basically, the toolbar is exclusive to the one file.