Hi there,
I have a textbox1 in Active sheet (Sheet1).
How do I change the caption of this textbox1 from userform command button 1?
Thanks,

In a business spreadsheet, every time a predetermined condition is met I need
to record information on a "running" record.  Ie. When condition 'A' is met,
copy data to; 'Sheet1!E {nextblank}.  As there will be a few things I need to
record, I would like it all on the same row.  ...

If I pass a named range as a parameter to a user defined function, it returns
#value!
I created several named ranges.  
For Example

I have a very simple Message Box that appears when a file is opened.
How could I have a variable referred to within this message box e.g if
my text to appear in the message box was referenced to G1 in sheet
"Sales"?

Hi, someone please provide me the code for following column in excel.
Like I have a column a and column b. In column a, I have time and in
column b, I have time in 0:30 minutes interval. So consolidating column
a into column b with half an hour difference. I want a macro or script

I need some macro help. There are two components to my problem.
1. Match Cells to Identify Target Column
In Sheet "Menu", I enter a date in cell "C3". Lets call it DATE.
In Sheet "Metrics", I have a Table Similar to the one below

Hello,
I have several Excel Templates that open on automated PC using scheduled
tasks.  The templates run through a series of code.  The templates all work
fine on my laptop.  However, they are often times running into a "Code

I'd like to know if there is any way in VBScript Excel 2003, to determine
whether the current user is a system administrator.  I have a custom addin
that I only want the uninstall to be run if the user is a system
administrator.

Hi! I have a macro that opens an excel file and activates it. How do I get it
to start at a certain worksheet?
Workbooks.Open "X:\SCD_RiskManager_Pos\RMDBII\test.xls" 'open file
   Workbooks("test.xls").Activate   'ACTIVATE FILE

Sorry for my Enghlih !
I have a excel workbook being a having all details obout 1 house te bild.
8 commandbuttons in cellrow1 of columns S>Z prints each another selection of
the rows.

This was the formula that was given to me to accomplish my task:  
=Average(Indirect("G1:G"&E7)).  However it doesn't work or I have done
something wrong in entering the formula.  Here is a jpeg of what I am trying
to do and hopefully I will get a better result this time around.

I was wondering if anyone could help me out.  I'd like to remove a custom
addin that I've added from the list of available addins from Excel 2003.
I know Excel will complain the next time it opens that the addin no longer
exists but I'd like to prevent that from happening.

I have a counter "i" in subroutine 1. How can I use this counter in
another subroutine? Is this possible? Please let me know. Thanks

Sub insert()
Dim r As Range
Dim rd As Range
Set r = Range("H2")

My macro below is not working properly:
Sub Deletedepo()
With ActiveSheet
.DisplayPageBreaks = False