Can an item (a line with arrowhead as created by the Drawing function for
example)  be created and/or the color of it changed by  an entry or entries
in a Macro when certain conditions exist?
If this can be done, how is it done?

I have modified some code written by Chip Pearson. The code works perfectly.
Basically the code takes the content of a cell and places it in the header. I
need to add additional code to bold the header. I am calling the sub with the
Workbook_BeforePrint event.

Is there a way to copy a cell content into a TextBox with a macro? If i try
to register the steps it doesn't work.
I have to fill many textbox (is "textbox" correct? I've the italian version
and it's "casella di testo"..) at once with data from a form.

Where can I find a listing of VB code and the syntax for usage.  I don't
want a page full of solutions.  I want the code words and what they mean
or do.  This may be way too fundamental for this venue but I hope that
someone can provide some clues.

hi, hope I can ask this clearly.
a                  b    c    d    e       f         g         h                   i     j
k    l
09/10/2004    14    11    18    Walsall    2           1      Colchester     9    4    3

How do you write a source in code in VB Code for a ComboBox3 on an Excel
UserForm where the source is horizontal range.  For example Sheet2!E2:H2.

I am wondering if there is a way of changing the code in the VBE for other
Excel files while the target Excel file is already closed.  Is this possible?
How would I code this?

I am trying to run a macro to save a file but want to obtain the filename
from the contents of a specific cell

VB gurus please help!
I have conditional formatting specified as worksheet change event code
using the case select method.  However, in order to correctly set the
range of interest, I need to de-select any autofiltering and also

How can I call a function in the code from a worksheet while in the code for
a form? For example, I have a function called GetData1 in a worksheet
"Part#". I want to call this functio from the VB code in a form "Status", but
'Call GetData1' doesn't work. Neither does 'Call Part# ...

I have some code that runs during the Workbook_BeforeClose procedure.  I
have a Main Menu menu bar that I want to remove when the user closes the
workbook.
The code works with out problem, but, if the user is prompted to save the

I heed some help to create a form that I can use to switch sheets.  The
reason is I have a workbook that has so many sheets I can't always see them
all.
I do have some VBA experience and will be abe to edit.

I was wondering if the is something within VBA that checks if a cell is empty
or null. I would like to incorporate something like that within the code I am
working on. thanks.

Is there a way to quickly select multiple cells to equal one other
cell?:confused:

 I have an XLL that works just fine on my development machine (don't they
always). Excel 2003 sp2, WinXP Pro.  
 If I copy my add-in to a Citrix environment and add it to the add-ins in
Excel it works once. After I close Excel and then start it back up I get