How do I call up the Find dialog box in a macro and have the macro goto the
data requested in the find dialog?
I've tried recording a macro and going to Find on the Edit menu and also
CTRL F to bring up the diaog box but neither work.

Could some explain how, through code, you  "Save" the sheet when you
close a Form, so you don't get the message, "Are you sure
you want to save changes..." when you close the workbook ?
Many thanks - Kirk

Private Sub UserForm_Activate()
'Load the List of Customer Contacts
Application.ScreenUpdating = False
Dim LastCell As Long

I would like to use the values of a range of cells in an SQL query, but
I'm not sure the best way to do it. Basically, the value of each cell
would be part of a string, each separated by a comma. I could build an
array to loop through each value in the range and append a comma, ...

Hi all, here is what I am trying to do with the data below: I would
like to take the revenue received from the closed contract and spread
it out over the length of the contract, dividing it up by the fiscal
quarters.  I have tried numerous ways to do this but cannot seem to

WOW - those last answers not only worked well but were som mcuh faster that
my code - I LOVE this forum!!!
Below is anouther loop I am using - it works but is slow and inefficient -
any suggestions for improvement would be muxh appreciated. Not sure how to

I am facing problem in writing macro / vb code in excel.
It is not allowing me to copy more than 256 chars of a cell.
Is there any solution to this problem??

In Excel, say i have two columns :
COl1     Col2
A           1
B           2

I have been trying to get edit box input from the dialog box to my control
sheet and am stuck.  I have done this before but it may have been on an
earlier version of excel.  Here's what I thought I could do:
Range("FirstNameBox").Text = Sheets("control").Range("FirstName").Text

Below is my code:
Sub report()
Application.ScreenUpdating = False
Dim res As Variant, sName As String

I have created a small form and routine that starts when a workbook is
opened to briefly displays a "splash screen" and then disappear.
This works great on a PC, but requires that I display the form as non-
modal.  Since macs can only display forms as modal, the form will

I have a problem with one of my files where there is a drop-down box that is
suposed to populate a few textboxes however at times it won't populate, what
could be going on here?
Thanks in advance

I am trying to create a Pivot Table to show the WOS (weeks of stock)
by week for YOY (2005, 2006 and 2007) for certain product families.
WOS = OH/AWS where OH = On Hands (available data) and AWS = Average
weekly sales (also available data). I did the WOS calculations myself

Is there any way to have a for/next loop to search a Column for
months? One specific column has inventory number information as well
as date separators, the dates are in "mmm-yy" format.
Sub FindDate()

I am using VB to query a group of text files for buzzwords contained within
them.  But to simplify my situation I will say I am only interested in
determining the modified date of each file.  I have attempted to use an error
handler within a for loop.