I've googled this question with every permutation I can think of and
kind find an answer.
I have created a multipage tabbed form for data entry. The tab behavior
on the first multipage works as expected.  Sporadically, on the second

I have a worksheet which in which i want to start up a list box where i can
choose from the list to enter into the cell, the cell in question happens to
be a merged cell of 4 cells.
Also i want the list to be already loaded when the worksheet is opened.

I have a complicated application which runs using a listbox on a userform to
display the contents of an area of a workbook.  The listbox allows multiple
selections.
I have written functionality which depending on whether the user checks or

Hi,
Can anyone identify the error in my looping? My IsNumber(f) is not
working. If I enter a string, an error message will pop up, but if I
enter a number (e.g 4 or -4), the same error message pops up too...what

Following procedures
-------------------------------------------------------------
Private Sub ScrollBar1_Change()
Range("A1").Value = ScrollBar1.Value

I am trying to write a procedure which sets the couponrate to 0 if the
user did not enter anything(Optional), and sets the couponrate to the
positive value the user has entered in. However, my codes are not
working!!:(

Hi all, i have been trying write a marco to extract the date portio
from date:time. The problem is the latter(date:time) is in strin
format and when i used the left() function to extract the date, i
automatically converts into date format. How can i prevent this??

Microsoft Excel 2003
I have created a button on a spreadsheet using the following code
   ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1",
Link:=False _

I've got a date range on one sheet, and data on another.  My data sheet
has a column of dates.  I want to add a button next to my date ranges
to highlight the rows on my data sheet if they fall into that date
range.  Does that make sense?  Can anybody help me?

We run a very long product list in Excel which is prequently updated.
We need a formula that identifies and removes identical product names.

I'd like advice on the best way to save a group of macros for a specific
report on about 8 separate PC's used by 8 separate people.  Each of these
folks will need to run this report on a daily basis.  I was thinking using
the Personal workbook might not be best because if I have ...

I had read a code to change the Excel Logo at Application.Caption bar.
However I forget, any suggestion?

I have VBA code called "savetoron" in a spreadsheet (Max OSX, Excel
2004) which reads some data from certain cells and constructs a
filename, then saves that spreadsheet, with that filename, to a certain
location, and closes that file on the screen. It reads like this:

I have a spreadsheet with a CommandButton1.  I have set the Enable
properties to False.  I also have a macro in the file I want to use to Enable
the CommandButton1.  I'm using the following code:
CommandButton1.Enabled = True

Hi All
I have an Excel Sheet named  "Stats"and Column D contains a list of
alphanumeric numbers down to row 2000 after every 20 rows there are 2 rows of
headings is it possible to have a routine that will find the same unique