Is it possible design a user form with cusomised controls ?
I built a userform with multipage control.
Page 1                     Page2                  Page3
1 label                     1 label                  1 label

I have a worksheet that contains 12 budgets (one for each month).  Each
budget is identical in size (rows & columns).  I have two commandbuttons that
allow me to sort two different ways.  The user simply enters the month
(numeric value 1-12) and that particular budget is sorted.

I need to get the numeric value of Activecell.Address into a variable so that
I can do calculations.  Example:  ActiveCell.Address = $F$426.  I need to
pull out 426 and place in a variable.
How can this be accomplished?

Hi all, Good Morning
Please let me know the code mistake in- following and request to
rectify the same.
Sub Ramaa()

I would use application.filesearch in a excel macro
for searching the body text of PDF files, it works with office files but not
with pdf.
Any possible solution or alternatives to filesearch?

Can I get some help coding something like the following:
If Range("E1").value = "YTD" then
   'cut columns E, F, G
   'paste columns E, F, G in front of column B

I now nothing about macros so am looking for help. i want to be able to have
a macro so that i use button it will bring up a calander to select a
particular week and add into time sheet. i also want to be able to click
another button and i will be able to change amount of hours ...

In my worksheet I have a number of hidden sheets.
I need a macro in which I can select 1 of the hidden sheets, and unhide it.
Can anyone help?
thanks.

Hello
The following code deletes VBA in the file for users however I get a runtime
error 13 on the following line for those that are still using Excel 97.  Is
there code that will work for Excel 97 and later versions or is this a

Hello.  I am using a form (several actually) with drop-down lists.  My
program is used by unskilled computer people, and I have tried to make
it user-friendly and error-resistant, but I found an unexpected
problem.  I do not know what to do about this one.

Is there a way I can prevent the "Contacting the server for information"
message from appearing when I am programmatically opening Excel files stored
on a SharePoint Server?  I'm opening lots of files in my code and the
message appears almost every time.  The message is a real ...

I have this excel sheet that has a bunch of formulas in it.  My formulas
look at cells in the previous row. If I delete a row,  the cells change to
#REF!  This makes sense to me.  Is there a way to write the formula so that
is just looks at the prior row instead of trying to find ...

what is equivalent VBA to old macro keystrokes:{edit}{home}({end})*0{enter}
I want to simply enclose the contents (number or formula) of current/active
cell and multipy by zero. the keystroke recorder only will allow recording of
the actual contents as permanent text string or ...

I am using Interior.ColorIndex in Sheet1 to define Work Hours per day,
8, 9, 10...
and Font.ColorIndex to define Week Worked days, 5, 6  or 7
which in turn with a Select Case allows me to call the applicable Rate

I'm new to VBA programming, and I'm trying to run the code found at:
http://www.microsoft.com/technet/scriptcenter/resources/officetips/may05/tips050
3.mspx
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True