1. How do I add text to a combo box without doing all the code stuff that I
don't understand? 2. I've added equally spaced text boxes to my frame, which
are snapped in alignment. When I want to enter data from one box to another,
It won't let me tab.  I have to click directly on ...

I am somewhat familiar with simple functions in Excel and I know there is a
way to do this but I need some help.  
I have a worksheet (#1) with 4 columns,
column A goes from 61 to 99

I am somewhat familiar with basic Excel functions but I need some help on a
worksheet I am working on.
I have a worksheet (#1) that has 4 columns:  Column A has numbers listed 61
thru 99, Columns B, C & D are numerical ranges refering to Column A (e.g.,

How do I remove the last three letters of a string?

 I have a text string in cell A1 and I am trying to do an If Statement that
would place a certain value in B1 if something is contained in the text
string.  I know this is probably simple, but have looked and I am stumped.
Cell A1 contains the following:

Is there any utilities out there that will obfuscate the vba code?
What is the difference with com addin compared to a dll addin?
Which one of those can call a secondary addin?
Is there any limitations of moving the VBA code over to a addin?

I wish to calculate yields using monthly compounding.  Excel spreadsheet has
a 'yield' function that allows 1, 2, or 4 compound periods per year (I need
12).  I have a custom function written by a friend that calculates yield,
but it too, does not calculate monthly compounding.  ...

Hi again
Im trying to write that if there is a value in a cell write in the one
beneath it
Thanks Michael

Here is the formula for the beginning month:
datMonBeg = DateSerial(Year(objCell.Offset(0, 5).Value),
Month(objCell.Offset(0, 4).Value), 1)
Now I want to reference the following month.  Is there a simple formula for

I'm trying to write that if a variable equals a value then find a cell that
equals the same amount and type in another variables value in to the cell
next to it.
Thanks Michael

I wish to include cell reference as parameters to a Data Import module that
I have recorded but not sure of the syntax. What I have recorded works great
but when I want to modify the dates I have to change the hard code. My dates
within the macro are currently between 31/05/2004 and ...

HAPPY NEW TO ALL!!
Simple question, is it possible vertically align text in a label or textbox?
Thanks to all and may 2005 be the best ever.
CHEERS!!

In a new wb and ws:
In the Immediate Window I enter:
range("A1:A10").Name = "TestRange"
? Range("TestRange").address

The time taken to load my Excel 2000 workbooks increases by 30 sec for
each VBA control used. Run time is unaffected. I think this delay is
recent, does not depend on the size of VBA code and is increasing with
use of the workbooks. The computer is running Norton Antivirus and

I have this simple code:
sub printsheet()
   If Worksheets(1).Cells(1, 1) <> " " Then Worksheets(1).printout
   End If