I would like to initialize a text box in a user form with the last day of the
month calculated from the current date (Today)
I tried the following:
Private Sub UserForm_Initialize()

Hi, I was wondering if anyone knew how I could expand the viewable items
shown in a drop down menu... I have a drop down menu with a large amount of
items and would like to show a larger porion of the list to choose from when
the drop down menu button is clicked (currently is ...

I have a VB 6.0 application that creates reports using Excel 2000.  The
application has been working fine but recently I installed it on a new hard
drive (same configuration) and now I get a run time error every time I try to
save the excel report.  The error is:  Runtime error ...

Hi, I would like to know how duplicate a Sheet in excel.
I know only how create a new sheet :     xExcel>>Sheets>>Add()
I tried to copy the sheet, create a new sheet, and paste, but it
doesn't work, because Excel display a prompt.

I am in the process of creating a spreadsheet (a form to be precise)
where users insert data. The form is then sent to myself for collation.
I am trying to automate the process for the creation of the file name.
I have come up with the following:

I need to enter the same date in 3 work book, my question is what ever data
i enter in work book 1 needs to be updated in work book 2 & 3 is it possible
pls suggest.

I'm trying to determine the location of a cell within a range. I know
that you can access cells in a range sequentially using
range(_).cells(1), .cells(2), etc. What I'd like to be able to do is
determine the 'i' for which range(_).cells(i) is the given cell. I can

I have range (ActiveCell.CurrentRegion) and I want to know the last cell in
the range.
I know that vba has this property but i don't remember it.
Anyone know?

I'm trying to dynamically direct some XL QueryTables to the 'correct' MS
Access database (local on C:\ ,  or on network drive).
The XL file with the QueryTables may be executed either on a network drive
or on my hard drive.

I want to declare some arrays of constants.
One array has 5 elements as String, and some other arrays can have up to 100
elements as Single.
Can I do it in a single statement like: "Const InterestRate as Single =

I often use the row right click menu to add a row. I find that when I
have something on my clipboard the "Insert" command is replaced with a
"Insert copied cells" I find this a pain as I have to press escape to
cancel the copy command, insert the row, go back to where the source is

I am currently working on a VBA program that reads image files from a
folder (Jpegs, incidentally). I have produced a mockup that requires
Image objects to already be defined (like I newbie, I just dragged them
from the toolbox!). Is it possible to iteratively create Image objects

how can i remove repeated names in a column?

Sub Test()
   Dim c      As Range
   Dim rng    As Range
   Dim rng1   As Range

Im not sure if anyone out there can remember, a previous
version of Excel there was a way of collapsing and expanding sheets
within a workbook...A little plus on the sheet that if you clicked you
would see several sheets, like a workbook within a workbook.. does that