I copied the code below right out of Excel VBA Help, changing only the
folder specified in ".Lookin" to "C:\Tsfr". I know this folder exists on my
computer and contains three .doc files. Therefore the code should report
three files found, but instead it erroneously reports no ...

Hello, I am not too familiar with errors in my code and was hoping for
some help with this please.
I have a control box linked to a stock spreadsheet. After I update this
box(Which is for the stock number), the label next to it will update

in an Excel VBA program, I'd like to download a couple of images
(address determined on runtime) from the internet and have them
displayed on my userform.
I would like _not_ to download the image and export to disk it as a

Group,
I'll ask this a different way with more detail.  I have
For.....Next loop that goes from row 46 to some unknown number les
than 2000.  I increment a counter that moves me down the first colum

Trying to find the best solution to the following:
I have a number of Subs in different modules that are using the same
function.
These Subs have to pass a large number of variables of different types

I am trying to make an Excel-spreadsheet, based on Sudoku puzzle.
So , cells a1 to i1   have to be filled with the numbers 1 to 9, in random
order.
    a

Hi I have been working on a problem i have had for a few days now and
have come up with an easy solution to the problem.
I need a bit of help with the code but I have some of it worked out.
Here goes -

Currently I use the following code to populate a cell on my worksheet from a
TextBox on a DialogBox:
Private Sub CommandButton1_Click()
   Dim rng

I am new in Excel programming.
I need to check if a cell contains a substring, something like "*excel*".
First, I tried
Set d = .Find(cdnName, LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False)

I had write a code  to send  an email via Outlook, just to one person.
My question:
How can I send it to multiple persons like:
To: email1; email2; etc. and

in column A (A5:A370) are dates from 01-01-2005 to 31-12-2005
in column B (B5:B370) are the week no. for each date, produced by
following formula:
=ROUNDDOWN(((A7-WEEKDAY(A7,2)-DATE(YEAR(A7+4-WEEKDAY(A7,2)),1,-10))/7),0)

hello, I have a box used exclusivley for date entry. If someone does not
enter it in this format "DD/MM/YYYY" then a msgbox appears saying "Date
must be entered in this format...". When this incorrect entry occurs I
would like to force the user to stay in the date box until he has

The code below enters True when the CheckBox is checked, and False when it
is not. Is there any way to have it place an X when the checkbox is checked
and nothing when it is not checked?
rng(1, 3).Value = CheckBox1.Value

   I'd like to have my spreadsheet to update automatically (don't know if
that's possible).
  In order to do so, it needs to be able to do the following:
1) Is it a way to pass it arguments when lauching Excel, e.g. file name,

   My son is tracking the weather. He keeps track of all the temps. He
would like to conditionally format them in increments of 10 degrees(eg.
70's- blue; 80's - purple; etc.).
How can he do it for more than 3 conditions? Thanks Jim