I display a userform with a progress bar (from 0% to 100%). The progress bar
is displayed correctly until I click on the form. When this happens, the box
and the percentage freeze (not responding). The macro continu to run
correctly but it doesn't update the percentage thereafter ...

I have read through the various posting trying to get this sorted and found a
bubble sort from Tom Ogilvy, but its not working. Can somene work out what I
may have done wrong? The full code is below:
Private FileNameList(1 To 20, 1 To 2), FileListCount As Integer

Hello,
I'm just wondering if it's possible to check to see if something exists
within a collection before proceeding, I can do it with putting various "On
error goto" statements, but I was just wondering if it's be possible to do

How do l refer to a workbook level named range?
I was expecting to use something like this:
ThisWorkbook.Names = "MyRange"
Regards

any suggestion for how is possible to sort a data in a column base on the
first two digits of the data in each cell. suppose that i have colume in
which some names are randomly put, now i would like to make new column in
different sheets and sort this random names in them in ...

=IF(H5=$C$2,"=VLOOKUP(H4,$B$5:$C$11,2,FALSE)",0)
Hi all,
Above is my simple nested vlookup statement.
The problem is, it may be too simple.

Thanks in advance for all your help. I have two questions.
Question 1:
-------------
I want to change this:

Dear Sir,
I have a userform with text box "DatePurchase" and other textboxes.
when I load my userform and when I entered the data it is working
fine,

I have 3 xls ex: exl1, exl2 & exl3, any data entered in exl1 of column  A and
data entered in exl2 of column D to be automatically added in column A of
exl3, kindly help pls........
TIA

I have developed some code for Excel application through which i am going to
create an excel appliaction and open a workbook by name "ABC.xls" and insert
a value of 500 in sheet by name "sheet1" in the cell(10,10). Now my
requirement goes some thing like this. I used the code ...

Hi everybody.  Well, I've spent the requisite 4+ hours looking in
manuals, searching the Internet and this group, and I'm totally
confused about how Excel works with regard to "databases" and forms
and macros.  I have moderate understanding of spreadsheets (e.g.

I have a set of about a dozen pictures on a worksheet, all linked to the same
macro.  When the Shape is clicked, the common macro executes.  How can I
determine which Shape the user clicked?

In a range B1:AE1, I have formulae’s which converts the date from B2:AE2 to
days i.e., “Sun”, “Mon”, “Tue” and so on. I only change the first day of
every month in B2 where all dates gets auto-populated in the subsequent range
of cells.

the restriction or known as IF is suppused to look at 2 cells to get
a
date time frame. cell1 is 6/1/2007 and cell2  5/31/2008. i need it to
look between that time frame or any dates inserted into those 2

Hi all...
I am importing data from one workbook to another.  I have it owrking fine on
a local location c:\ to c:\ but it will need to work across network
locations (possible mapped netwrk drives).  Would really appreciate some