I am wondering if I could get some help or suggestions on how do do a
particular type of task.
The problem is that I don't know how to even google what I am trying
to ask because I am sure my question is not new.

I have a UserForm with a Multipage Control (mpgPaint).  Each Page is Named
pgColor1, pgColor2, pgColor3, pgColor4, pgColor5, & pgColor6.  On each page
there are two checkboxes named chk1stSurfaceP1 & chk2ndSurfaceP1 (the number
1 represents what page it is on).  How can I cycle ...

Need to hide rows that a certain range sums to zero in, which the code below
does.
What it also does is hide any blank rows as well, which does not work for
the intended purpose.

The code snippet below loops thru a series of different option buttons
on a form. What l now need to do is assign the result of each
iteration to a variable. So in this case the 1st iteration would
assign the result to the variable C1. How can l amend the code so that

I have many people using the file. Each person only needs a page worth of
information. I need a Macro to print curent page only.

i need a macro to save my excel file as per the activecell name
example: if my active cell is "A1" and in A1 i have typed a word called as
John, so the same workbook need to be saved in John's name to my C: drive.

I’d like a way to flesh out a file’s path the way the Dir() function
does.  The Dir() function (like the DIR command in DOS) fills in
missing components depending on what the current Path is set to.
Suppose the current Path is

Hi, All,
I am on a project where i want to zip an excel fil using macro. Is it
possible. If yes, please let me knoe the coding.
Your suggestion would be very valuable for me.

How can I enable all Pages of a Multipage Control it a checkbox = True, and
disable pages it the checkbox = False?
Sub EnablePages ()
Dim myPages as Collection

I have 3 seperate excle(Crystal.xls, AMETITSG.xls, ITSGAsia.xls).
If any data added in Column A of Crystal.xls and any data added in column D
of AMETITSG.xls should be automatically added in Column A of ITSGAsia.xls
TIA

I have created a WortArt object in Excel programatically using VBA and using
the preset text effect style msoTextEffect3. Unfortunately, this creates text
with the color red. Now I can right click on the word art and change the
color of the text to whatever I want. But I cannot ...

Does anyone know if it's possible to expand / collapse groupings using
VBA. I tried using the macro recorder but no code is generated when
you expand / collapse a group.
Any suggestions?

I am a complete novice to VB and MS (MicroSoft)technologies so please bear
with me.
Here is the problem:
I have a parent folder called "Production". Under Production i have many

I want to sort an array using VBA independently of the spreadsheet. Thus I
have an array with 150 rows and 8 columns with the first column characters. I
wish to select any column and order that column by value and maintain the
relationship with the other columns. Apparently VBA ...

I have a UserForm and I put the restriction on the "DatePurchase"
textbox. so user can not skip this field. it is working fine.  I used
the following code for that.
Private Sub DatePurchase_Exit(ByVal Cancel As MSForms.ReturnBoolean)