I need a progress bar that will be used in the status bar. Somethin
like the one that runs when you open a really big workbook or one lik
when it calculates your worksheets. Is there any vba code that would d
this jobe nicely. I know the application.statusbar.value = "Creatin

I'm trying to figure out how to do this in a user form and have no idea how
to do so/manipulate the output, so looking for suggestions.
I want to put out a list of 10 numbers, with some sort of separator as one
of the 'rows'.  Then have a spinbutton which will move the separator ...

I have a form which when I press a command button, it will bring up the
screen asking where I want to save it, all pretty normal except I want
the default save filename to be derived from cells in the spreadsheet
and todays date.

In Column "AT" (46) I have seed companies listed starting in row 2 on down
with a count of the number of seed companies in row 1.  In Column "AS" (45) I
have a count of the number of hybrids for each seed company with the hybrids
listed, next to the appropriate seed company, in ...

I have been hitting my head with the wall since i m new to VBA, i wis
to block the whole sheet for data entry except the very first row fo
data entry. as the user complete the first row for data entry, He/Sh
will press a button to paste the record to another sheet and afte

We produce a number of Excel Add-ins that get loaded just after Excel
opens.
We have a recurring bug, which is that after loading our Add-ins, Excel
will not show the graphics in any file. They are still there but the

Below is a small bit of code that will make a row bold depending on
value in column Q.
I can make it work if the value in Q is text, however I need it to rea
a datevalue. Is there a way to do this?

I need to activate a workbook through a cell reference. the workook
name is stored in cell A1 as "pnlreport_060321.xls". This name
automatically changes daily based on the date. This is how I wrote the
code to activate the workbook:

After I run a macro to format an Excel worksheet, I would like to be able to
permanently remove all the macro code so that when a new user is sent the
formatted Excel worksheet, there is no pop-up window warning about Macros and
there are no Macros within the macro window.

Is there a way to get a workbook to open in a new excel window rather then
one that is open?
Thanks in Advance
Jason Zischke

I have a sheet with one colum of results, those results I would like to
paste onto the next worksheet into the frist empty colum after the data of
the previous results, in order to create a kind of history.

I've got some code which runs through some cells to compile a list of
sheets within a workbook that I want to copy out into a separate
workbook.
I've been compiling a string of the relevant worksheet names that I

Dear gurus,
I have a VBA program and one of the command is :
Charts.Add
This works fine for some spreadsheets.  On other sheets, on different

I've created a class module containing methods and properties.
Everything works fine.
However....
When I expose the methods and properties after instantiating the class

what's the preferred way to do this?
let's say there's a master workbook and child workbooks. the procedure is to
load and copy child data to the master which is already loaded.
when you use the with workbook statement, is it preferred to use: