Hi Everyone,
What I want to be able to do is enter the payment, interest rate, and number
of years on a loan and then have the spread sheet tell me how much I can
borrow. Does anyone know of any Excel templates that do this?

I'm trying to create a macro that will confine my text to its own cell (ie so
it doesn't spill over to the next). I know I could use alignment options
'text wrap' or 'shrink to fit' however I prefer what I call the cut-off look
where neither the cell nor the text are resized, ...

Using code rs.AddNew for a recordset, and I have placed the call at the
beginning of my code.  I then check to see if the Primary Key is violated, if
not the program proceeds, but if the PK is violated the program goes to the
next record.  Since you cannot close rs.AddNew (at ...

How can i open all workbooks (the number & name of workbooks may be
different) in a specific folder with one macro.
The path can be made dynamic by using "ThisWorkbook.Path"

I have a worksheet where i've used subtotals to separate out data into
subsets.  within those subsets I want to indicate which rows have the highest
and second highest value in a given column.  There are something like 100
groups, so doing it one subset at a time is not good.  ...

I use the following code to import records from a temporary spreadsheet to
the master log. Each record will have a unique date, and no two records
should be inserted into the master, with the same date.
Issue:  

I want to have an input box where I list an item.  There is a calculation run
pertaining to that item and it is given a numerical property.  Then I need
them all to be listed according to this property.  The order in which they
are listed then is the reference for the next item.

I want to be able to loop through column B and search for a value that is
stored in a text box (txtCriteria1) on my userform.  If the value is found in
column B, display  message saying 'exists', else, display a message that says
'does not exist'.

Is it possible to resize an userform from code.  That is, if I drop controls
on a form in the VBE but do not size the form, can I then resize in code at
run-time to accomodate the placement of the controls on the form?
Thanks

Good Afternoon-
I am writing a long macro and having a problem with one thing- after
concatenating a lot of different text values, and separating them by commas,
I have found that some of the composite values have trailing commas at the

I have a listbox with multiselect turned off and it triggers a macro which
calls up another form on the click event of the listbox.  If I want to turn
the multiselect on, how can I trigger the same macro.  Am I forced to have a
button and then use its click event.  That is, I ...

Ron,
I have looked at your website revisions and l think the explanation /
examples for changing the Ribbon are now much clearer.
I have followed / used your examples succesfully to the extent that l

Here is the scenerio,
I have a number like this 30-015-00745  in cells A2 to A150. The
important part of that number is the 3 middle digits. Example: 015
I have another page that lists several hundred 3 digit combinations.

I was able to take all the great info from
microsoft.public.excel.programming and create pop-up calendars in my
Excel spreadsheet.  The problem is that they wont function properly
when I protect my worksheet.  I keep getting the error shown below.

I have many sheets with a command button on it using the same code.
I want to change this so I have one code.
I put that code in a module and made it PUBLIC
Public Sub Process()