I have a userform with a number of Command Buttons (Button1, Button2,
etc...).  Before the form loads, I would like to change the caption of each
of the buttons (with the use of a loop) to the contents of certain cells.  
Can anyone help me with the syntax is to do so.  For ...

The below code works, but I need to be able to select the sheet first. Is it
possible to do this with selecting the sheet, which in my case is (Visible =
False)
   Sheets("sheetname").Select

I have been asked to set up a cell that will tell the user his or her
Accomplishment based on a percent.
So if a person is told to do 2 (Cell A1) and they did 2 (Cell A2)  the
person would be at 100%. so if the value falls between 100% to 105%  I would

I am trying to call a sub within another sub, i'll refer to the main
sub as sub1 and the sub within that as sub2.  I want sub2 to perform a
calculation and find result X.  How do I then use X in sub1?  why is X
not available to sub1?  

I have a macro which is assigned to a control box or button. However I do not
want the macro to run if a value is entered in another cell in the worksheet.
Eg
if Cell A1 has a drop down list and if "Apply Mannually" is chosen then the

I'm trying to send an open spreadsheet as an attachment from code in Outlook
2003. I tried using the excel command SendMail but that triggers a security
warning.
The code fails when I try to add the workbook as an attachment.

Hi! I am trying to clear contents in a range of cells but i fail with the
syntax. I want to clear contents starting at cell D5. I want the clear
contents to end where there is nothing more to the right of cell D5 and then
go down to find the last cell with content. I have tried ...

I am new to using VB with excel, so please be gental.  I am trying to
duplicat a push button that was created for one row of cells.  I want all
other rows of cells to have their own push buton with the same funcationality
only using the data from their row and output to their row ...

I am getting an error message of, "wrong number of arguments or invalid
property assignment" and .Borders is highlighted.  see between *@.  I was
hoping to avoid having a separate with statement for every xlEdgeLeft,
xlEdgeTop etc.   Can someone let me know if it can be done this ...

Hello again -
I am using Excel 2002 SP3 and  am working on a project involving collecting
data from 7-8 different sources with various col formats, etc.  It would be
neat if I could use an interface to define some functions to do this task.  

I am trying to call a sub within another sub, i'll refer to the main
sub as sub1 and the sub within that as sub2.  I want sub2 to perform a
calculation and find result X.  How do I then use X in sub1?  why is X
not available to sub1?  

I'm just starting to use List Boxes, and Multi Select List Boxes.
I would like to do the following:
I have a List Box with a Row Source that refers to Sheet inside the
Wookbook.  I would like to Click onto any one of the "Items" in the list Box

I have a question in opening a file from a macro used in Excel. I want the
file open to be flexible no matter what machine the Excel file is opened on,
but not sure how to do it. I've never learned VB in a class or anything and
have been learning it on my own. So, any help would ...

In windows explorer you can change the columns that are displayed so that
you can display more data than Filename, Size Modified Date and File Type.
If you select the View menu and Choose Details. Then you can selected Owner
and the Author fields. This gives you information about ...

I have written a function to interpolate either linearly or
exponentially but when using it keeps throwing up a #VALUE! error and
the debugger is no help.  Ultimately I want to be able to extend this
to include cubic spline and constrained cubic spline interpolation