I would like to find out what the format is for a cell (e.g., A1) and then
use that format to set the format of numbers I have on a chart in a dialog
box.  I have used the following to find the format:
   cf = Cells(1, 1).NumberFormat

I'm working with a VBA userform; in the fields are only digits and
letters allowed. How do I make this restriction?

I imported text and need to Ltrim all the cells in a given row.  How do
I do this?

All,
I'm combining 3 different worksheets in to one. It's pretty simple
code. The info veries with each worksheet, and all i'm trying to do is
make the cell in the next row down active.  any thoughts?  Here is my

I am working on a spreadsheet for our track team.  I am trying to get it so
the events that students are in are automatically shown when their name is
entered  in an event.  For example:
Cell B6 has an event.  Cells B7 to B10 have names of participants.  I want

With the following macro (copied from this usenet, modified & working
thank you) is there a way the row number (in this example 771) updates
automatically when I manually add rows between 3 & 771.
******************

Hi Group,
I am having trouble with the follwing. When I try and find, it says it is
not set.
Dim SerialNumber As String

I want to create an Excel template for creating quotations which has an
automatic numbering feature for the Quotation reference

I want to make a macro in excel that will go to the end of a data column and
do a summation of the data in the row immediately following the data.

What is the best way to copy data from a row, lets say row 2 cells 1 thru 15
to 15 text boxes on a form?
txt1= activeRow column 1
txt2=activeRow column 2

I like to call the worksheetfunction MATCH in VBA. I am using the
formula
=MATCH(2;1/(2:2<>"")) for getting the last used column. How do I
programm that with VBA?

I'm very new to this.  I'm trying to open a new worksheet and call it a
name.
However, I never know what sheet name excel is going to give me:
sometimes "Sheet1" or "Sheet10".  It depends on how many times I run

I want to create a macro that copies from one set of cells and copies to the
end of the range without regard to the original size.  Currently, all
variations copy over the last row of the previous copy, thus deleting one
line each time.   if the  Selection.End(xlDown).Select ...

All,
A colleague and myself are jointly developing an app using Excel 2003
sp2. Recently an issue has arisen where one of us cannot enter data
into a spreadsheet widget on one of our user forms. We use CVS for CM

I'm using a user form for users to select data, then once finished its
populated on an excel spreadsheet, i have no problems with part, but my
question is if the users need to change any part of the historical data,
which is assigned a task number how do i repopulate the user form ...