Have the following to check for blank cells. Would like to have message box
appear if blank cells exist. Then give user option to correct.  OR Maybe best
to just return to worksheet being checked if blank cells exist?
Thanks

I'm having a userform which on initialization should select one of the
values in the combo box control. This selection should be based on the
value of particular cell.
For example, if cell (B11) = 20, the selected value in comboBox upon

I am trying to delete rows based on 1. user selecting to overwrite data and
2.  criteria met in both column A and column B.  The code below is linked to
a button on a form with 3 possible selections and the form pops up when data
entered on another form is found to be duplicate ...

How are the Worksheets displayed from an AddIn? When AddIn in added,
I've created a custom menu which when selected calls a Subroutine in
the file which assumes that the Worksheets are open but it's not and
I'm getting errors...thanks.

I have a number of workbooks in a folder.  I created a Custom Property called
"Balance" for each workbook and assigned a value to each each workbook.
I then checked the settings by using:
File > Properties from the menu bar and all is good.

I am trying to determine a method which will allow me to sum a specific
number of cells in a row of data based on a cell value (in this case values
in col B). An example should be worth a 1000 words:
       A       B        C        D        E        F       G

I am having a problem usng this regex pattern in VBA:
[^"]\$[A-Z]*[0-9]
When I put it into quotes:
"[^"]\$[A-Z]*[0-9]"

I have a worksheet with 10 cells in which I want a  data picker tool.  I
thought I should be able to insert it into a selected cell much the same way
I insert a drop-down pick list.  But after searching about, it appears that
the only way is to create a vbscript for one-time use. ...

I need to copy a part of my sheet, which is limited to a fixed width, to a
Word doc, but when I did it, the width became too wide and exceeding the word
document boundary. Could you how to retain the width or other ways to get the
same result ?

I am attempting to create a standardised table of results from a set of lists
of varying lengths.  I have a similar set up working for lists of the same
length but addressing the source cell is much trickier when the list length
varies.

I posted this once already in microsoft.public.excel but I didn't get
an answer that really worked for me.  So hopefully putting it in
programming it will produce better results.  Anyway, sorry for the
double post...

I need assistance with a simple excel formula, with which i have been
struggling.
the file I am working a has column that has data from another sheet(using
vlookup).

How do you enter a formula that says if a cell is equal to or less than 5
type the text "reorder" if the cell is more than 5 type text "leave"

I program, but I am not a programmer.  Please forgive me if this
question is simplistic or naïve.  I am thinking of transitioning from
VBA to VB.net.  However, since VBA is tightly bound to Excel the
development process is very efficient because I can quickly iterate

I have read through the past posts and havent found exactly what I am looking
for.  I need to have a formula that will tell me how many months an employee
has worked after his anniversary THIS year, up to his anniversary NEXT year.  
I am able to make a formula that will calculate ...