my previous posting was not clear i think...
what can i add to a command so that when i click it, it checks that textbox1
got "mypass" and then run the sub
i have a textbox on a userform and a commandbutton1.

Could someone helps me?
I'm trying to write data on "TestData.txt", but place "TestData.txt" in the
same folder as my Excel program is placed.
Private Sub SaveThisSubInforGlobal()

Excel 2003, sp2
Hi,
I'm trying to hide columns X:IV so that the user only can see columns A:W.
However Selection.EntireColumn.Hidden = True raises an error - "The hidden

I want to create a subroutine that will accomplish four things:
1) insert rows above a range;
2) populate those rows;
3) sum the total of the inserted rows on to the named range; and

is there any way that i could have all my other worksheets import defined
name ranges from a source worksheet? and having them update every time i open
them or change the ranges in the source?
i made a data workbook for computing our production costs, and then, made

I have this code and 2 problems;
Sheets("calendar").Activate
Dim foundcell As Range
Dim this

I'm looking for my user to select a button which will take a date
entered in sheet 1 and find it in sheet 2. I then want to enter some
text in the column where the date was found.
However; I need to post the text in the first empty row in the next 13

I understand how to import external source data, and I am even getting
pretty good at using MSQuery to create QueryTables.
My question involves how to manipulate the query data in VBA prior to
outputing the query result onto a spreadsheet.

At work we are currently making a new spread sheet set up to manage
figures etc (well we are testing it etc).
There are a number of different spread sheet files that are all the
same apart from each one having some rows at the top with different

I think my subject line says it all.
How can I determine the number of columns & rows in the current version of
Excel that my addin is installed in?
Thanks in advance

After I sort ascending a worksheet within a workbook the first 30 rows
are blank.
I have a workbook with 4 worksheets and I want info to update from the
first one through all the others so I highlight A1 - 60L and paste

I have 600+ shapes in a spreadsheet. Half are the little red corner
associated with comments and half are small pictures in the same cell. How
can I select the picture in a given cell from VB?

Is this an efficient way to do this? (Code means nothing except
to illustrate)
' Get a certain range using passed-in row and column values
Function getRange(r as integer, c as integer) as Range

I have designed a userform so that if a customer has called in before I need
to view certain fields of their previous interaction. I have a textbox
"Customer ID" which I would like to searchh through a worksheet find that ID
# then populate the corresponding previous information.

Good evening Group,
Have been looking in the archive but not found a complete answer.
Is it possible to use the MATCH function in VBA when looking
for a date/time in format "YYYY-MM-DD  hh:mm"? The lookup array