Can someone help me with a macro / code to perform this task?
I have two excel files, or sheets... One is a list of different part
numbers in column A and their list prices in column B.  This is a LIST
PRICE file for a brand of parts my company sells.

I need to set my print settings to print duplex for a print job. I don't see any code samples anywhere I look which would shed light
on this. Please advise.
Thx in advance.

I have 2 questions:
First, is there a way to format a text box for dates.  One of the text boxes
on my form is for the user to enter a date. I would like to format the text
box so all the user has to do is enter mmddyy and the field is automatically

I have created a custom button and placed it on the toolbar.  Is there a way
to assign a Macro to it, without the macro being workbook specific?  Thanks.

How do I make a cell display the cell comments only when the cell is active?
I am using Excel 2000.

Is there a way for me to add code to my add-in file that will capture
the before_doubleclick event of the worksheet that is referencing the
add-in? I currently have thousands of worksheets that are referencing a
single add-in and I need to add a new procedure that gets triggered

I have formulas that refer to the values of 4 total cells c27-c30...
Hence, each cell can only take on 4 values...  How, besides the value,
can it take upon the cell background as well???
(c27-c28 is green, c29-c30 is red)...  I have tried:

If I assign a worksheet to the variable ws and a range to the variable rng,
why can't I then do a ws.rng.Select?
If I do it in two steps (i.e., ws.Select followed by a rng.Select),
everything works.

I'm having trouble understanding a simple behavior of Ranges. In the
following snippet...
Sub test()
   Dim rng As Range

When UserForm4 comes up, the user enters data in TextBox1. When the
user completes UserForm4, he clicks Next, and UserForm6 comes up. I
would like the number entered in TextBox1 of UserForm4 to automatically
populate TextBox7 of UserForm6.

is it safe to assume that calling Application.Run("MacroName", Args) will
wait till the macro is complete before proceeding?

This is my code...
ChDir "C:\Temp"
   Workbooks.OpenText Filename:="C:\Temp\myfile.txt", Origin:=xlWindows, _
       StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1),

As I wanted to alter the captions of the standard Msgbox I had a look at the
Messagebox API and
after altering some code I found it seems this is working nicely. I know I
could use a Userform for

Tried to write something like this:
[image: http://img461.imageshack.us/img461/7426/excel2co.jpg]
Here s the code:
Sub WriteFunctionTerm(TargetAdress, Order, xValueAdress, yValueAdress)

In the worksheet:
=SUM(Sheet1!A1:Sheet1!A13)
works just fine, giving the sum of cells.
In VBA: