May I know is there any way to change the icon of refedit control used
in userforms to the one shown in built-in dialog?
Thanks.

How do I protect/lock cells with hyperlinks yet still have users click on them.
I have a form in "Survey" tab for users to enter data.  Column F contains
all the questions, Column G is where users answer the questions, and column H
is where I want users to click a hyperlink if ...

I would like to create a Long User Form  (it would have a height greater than
the screen height), but I don't know how to create a User Form with Scroll
Bars that work. I set the form Height to say 1000. I turn on Scroll Bars
Vertical (2) and the form shows a scroll area, but ...

We have a labelling software that looks at Excel sheets to generate
labels.
I have recently made a simple MS Query to look at our company database
for the live information.

I pasted in a new module the following code from Patrick Molloy
in this group and the line
myformula ="=IF(ISERROR...... was immediately highlighted in Error.
I did not bother in this first try to Dim my variables.

I am developint COM addIn for excel 2003 using C# and .Net 2.0 interop.
In the code I am sibscribing to excel events like open, activate, etc.
It looks like it causing problem with any VBA addin installed that uses same
events.

At least it's making my head spin...
Sheet1 has sections so that A32 - A81 is part of one section.  I want to
loop through all the values in Sheet2, column D and if those values begin
with "6" then take the value from the same row in column E and place it in

Hi all need some help
Problem
I have a excel page and I want the user to enter his/her name in cell b4. I
want to validate this by saying if there is nothing entered in that field

Sorry for the cross posting, but I had posted this to the wrong forum
I want to prevent ptinting of my workbook without using the macro I
have set up for printing. I entered the code below to prevent
printing, but it also prevents my macro from printing. Any ideas how

I have a sheet with custom toolbars so users cannot use the standard
data - sort command (there is a valid reason for doing this).
I want to re-create something similar to the sort command.
So.

I now discovered the syntax to loop through rows:
example:
   For i = 3 To 20
       If Range("A" & i).Value = "" Then

Does anyone know how to get Excel to use the proper Framework for a Dotnet
DLL that needs the 2.0 Framework, but that is installed on a machine with
1.1 and 2.0 Frameworks?
An Excel reference to a VS 2005 (2.0) Windows Application, with an output

Is there a way I can wrap a vlookup in an IF statement to suppress #N/A
errors?  Something like...
=IF(VLOOKUP(X32,weights.xls!Soil1,3,FALSE)LIKE"#N/A,"",VLOOKUP_(X32,weights.xls!Soil1,3,FALSE))

Hello~
I need some assistance in writing a macro which could compare each
alpha-numeric character in each row of column I & J and hightlight (via font
color) the characters of column I which are different, then move to the next

Hi Focus,
I am trying to compare 2 values in different cell in separeted
workbooks, but the value of cell are different. So I need to use some
"substring" funcition to compare a part of value inside the cell with