1. Enter Excel workbook VBA code modules.
2. Select Tools > References, and it shows that "Microsoft Forms 2.0
Object Library" is checked.
3. Now, it's unable to uncheck "Microsoft Forms 2.0 Object Library".

I am in excel.  adding a hyperlink to a range.
So
Range.Hyperlinks.Add
Now it seems to want 2 items

How to pass a range object instead of to pass it's default value?
Clara

I am trying to figure out how to search through column B of Sheet1.  If
there are duplicates, display a message stating such, with the duplicate
value contained in the msgbox.
ideas?

I need to add scroll bars to the content of a MultiPage control. I've tried
everything that I can think of, and no hope.

This isn't a programming question but i figured ya'll would know everything,
does anyone know of a way to have a adobe doc (.pdf) and import to and excel
in the same format? I have tried text to columns but everything is too close
once it's in Excel, I tried to rename the .pdf to a  ...

Cannot update Personal.xls file. Updated file is lost and only prior
file is loaded. I have deleted prior file from xlstart, but it is
always loaded on startup regardless. I have used search to find where
this is coming from. Search says there is no file on the hard drive by

I am a complete novice with macros, but have been playing with some simple
examples.
I have a macro created that I want to delete, but when I navigate to
developer/macros and choose the macro, I am told I can't delete it because

I am trying to write a macro that would audit two columns of data for input
errors.  A small data set appears below:
Code    Fee
A5569    161

Anyone how i can use the "right" function and "format" function in Excel97
VBA coding?
thanks
Leung

I want to create a paste special button. My VBA is not as strong,
though.
ActiveCell.Select
   Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,

I am using the VBScript_RegExp_55 library in an Excel-based VBA project to
build a text-file processor that uses rules stored in an Excel spreadsheet.  
I have used Regex utilities before, so I understand the concepts of text
capture and re-use in a Regex expression.

Hi
I have the following problem in excel VBA:
I need to open a file with the name run1mmyyyy.
For example it must be opened for the months november 2006 to february 2007

I have a script that populates a cbo on activation, the user selects a
few options and slowly builds a list to create a txt file.
The issue I have is if the final list box is populated with anything
then you cannot change the cbo, so what I have done is added a

I have the:
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=True, Collate:=True
But is there a line i can add to set the printer to print only in Black and White?
Corey....