Hi, I am trying to use a command button on a user form which when
depressed, will return the value of a specific cell in the last row of
my worksheet and display that value in a text box on the user form.
Is there a way to do this?

Just one quick question concerning "Sort" macro...
I have the following code:
Sub SortAscending()
   Range("A1:A10000").AdvancedFilter Action:=xlFilterCopy,

I have a problem with a userform. This userform is shown when the user clicks
on a button in the excel spreadsheet. The user is then to enter some info in
various fields in the userForm. However when the user submits erronous info
the program gives a message in a message box to ...

I have the following macro in VBE, but by running it an error occurs.
It is a compile error and the problem is the range with named ranges in
it.
Does someone have a solution? Thanks in advance!

Oh Wise Ones,
                     I added some new code to my workbook last week, that
before I left was working fine.  Today its returning an error.  No one else
in my group messes with the code, just me.  A routine inserts a row(at row 4)

I have code (started from vba code from this site... thanks!!!) where data is
exported from Excel to Access. It works correctly when put into a regular
Access table. When I try to export it to a SQL table, I get a run-time error
3219 - Invalid Operation. The code is below and the ...

i keep getting an error (object required )
   Arr(i, 1).Value = ActiveCell.Value
Why?  where have i gone wrong?
--------------------------------------------------

I get the error message "sub or function not defined" when I try to use ASIN
in VBA Excel. Works OK in the worksheet, asin gets changed to Asin when I
type it into VBA and Asin is listed as a function for VBA in the help but it
doesn't work?

I have a shared file where people enter a number in column B8 through 228. In
column K8 through 228 are formulas that look at the numbers in column B and
deliver a "Yes" or a "No." I want Excel to show user-form1 whenever a formula
delivers a "No." When the user-form is displayed ...

I have a problem with a userform. This userform is shown when the user clicks
on a button in the excel spreadsheet. The user is then to enter some info in
various fields in the userForm. However when the user submits erronous info
the program gives a message in a message box to ...

I have a userform. In this userform I want the user to be able to access a
users manual (preferably in the form of a .pdf-file).  How the user can
access the users manual is of little importance as long as it is convenient
e.g. by pressing a button but preferably the user shall ...

is their a way to create your own error message
have a work book with protected cells , can i get the default message to
read something like
you arre not authorised to alter this data

I am writing an XLL for interfacing my code to Excel. I'm an experienced
Unix/C++ programmer but new to MS code development.
I have written a number of functions that all register correctly with Excel
but one, with 21 arguments, fails to register returning error code 4

I have a situation where I want to match 5,000 part numbers in one workbook
against a seoarate 10,000 master part number workbook, copy two cells from
the matched row and paste them in the original workbook row. The search would
also be a loop for the 5,000 workbook.

i based the following code on an example from copy files to other folder,
recorded march 31, 2006
Sub copyfolder_con()
Dim strfom, strto As String