To update the items on a userform I am using "userform.hide" and
"userform.show" at the beginning and end of the procedure.  Is there a better
way to update the data on a userform?
Thanks

I've done a lot of searching on this but am stuck - I'm guessing the answer
is simple - basically, I have a large file with 65 sheets -- on 15 of these
sheets, I would like to have them protected, but still allow the user to do
things such as sort, autofilter, format, and a few ...

How do I get a curser to move to a textbox in a userform when a button is
clicked?
Thanks

Race times are ranked in a worksheet by fastest times regardless of gender.
I wish to create seperate lists of athletes in another worksheet from that
information but listed by gender.
Column A has "male" or "female" and the rest of the row has other info such

A mean/variance asset allocation optimization model using inputs from various
investment indices (e.g. S&P500, Dow Jones, short-term Treasuries, etc.)
and/or individual investments (e.g. IBM, Ford, 10-year Treasury, etc.). The
output would be either an efficient frontier to data ...

If you use "For each wks in ActiveWorkbook. Worksheets", is there a way to
leave out a sheet, for example the Summary Sheet?  Or do I need to figure out
another way? Thanks!

I have created a macro that, among other things, copies a formula from the
first row of records to the remaining rows of records in the spreadsheet of
data that I exported to Excel from an accounting application.
Now, is there a way in VBA Editor that I can tell the macro to copy ...

Hello and HELP!
I need to copy some cells in various rows and also return the sheet name to
a master sheet where all will be layed out in a row.  I'm running into
problems because some of the cells I need to get are merged and plus I don't

I am trying to write a VBA code that will take the selected Pie chart and
modify the size of the chart and the plot area. This is my first venture into
VBA and I'm not having much luck. Was wondering if someone could point me in
the right direction.

What is the terminology to describe the type of property/object that does
not trigger the intellisense (the properties/methods dropdowns and function
definition tooltips).  For example, "Selection" vs. "ActiveCell".  Selection
will not trigger the intellisense stuff, whereas ...

Hi,
I am trying to copy everything on these three pages on to another sheet in
another workbook.  I'm having trouble getting this to work.  Can I do it this
way?

I have devloped a macro to automate a report.
in this macro I have many module. When we click alt + F8 to run the
macro , I see all the list of module.I just want ot show only main
module. is there any way to hide other module except main module.

Hello.  I fear I may be running into a limitation of VBA, but figured
I'd check with the gurus to see if I'm doing anything silly.
When I manually insert a photo (Insert | Picture | <filename>) in
Excel (Office 12), it allows me to use an URL for my filename (eg.

I got this problem which is driving me nuts.
In a macro i have the following line
ThisWorkbook.Sheets("Home").Range("C4").Select
I want to do this to be a bit more user friendly.

I have an Excel 2003 workbook with 2 worksheets that I manipulate in
the grouped mode.
There is a row on one sheet named "Bid row".  The user can put an x in
rows that he wants to have visible after a macro runs.