I am getting a "Error '9' : Subscript out of range" error while opening
a user form from a button on a sheet. Why is this happening? I checked
for typo errors, but there aren't any. What do I do?
Peace,

hi, is it possible for a MS-Excel 2000 to Create a drop-down list from a
range of cells? how?

I've been scouring the groups looking for a solution to this and I've
found many people with similar problems but none of the solutions
proposed work for me. I'm sure it's my lack of familiarity with VBA and
its implementation that's holding me back.

How can I adjust audio volume (for wav, MIDI, mp3 files) from within Excel ?
What declarations and functions would I need ?
Thanks,
AP

Hi
is it possible to always force a particular worksheet to be the visible
active one every time the spreadsheet is opened?
So for example if I have sheet1 and sheet2, and save the spreadsheet while

I am trying to have Excel pull out into one or more cells the name an
extension of ALL the workbooks open
I have found two ways but none is completely satisfactory so far:
- builda user form: shows the names but I cant find a way to paste the

I have VBA procedure that draws barcodes on MSAccess report, using Image
control from Acess toolbox (to be more exact: it sets the
ImageControl.PictureData property to some calculated binary value in bmp
format).

OK I get this error message "type  mixturte in ByReference argument". The
code is:
Sub chartID(i As Integer)
Dim s, t As String

Hi Group
I am trying to prevent unauthorised editing of rows in an excel
spreadsheet. My intention is to have a column where individuals select
their initials from a list and once they have selected their initials

We have problem with a spreadsheet where we use VBA to move inputed data in
cells within a column to
a row. The inputed data looks like, 0,3446325533953 and
0,45324657652432 etc, when moved to the assigned row it only have 3

I am running a simulation which creates a graph (covers almost the whole
sheet) on my Excel sheet. Also, there are some numbers on the bottom of
the sheet, which change as the simulation runs. I would like to see the
simulation running on the graph and the numbers changing on the ...

I need to run a VBA macro in Business Objects that saves an excel file
under a certain name - based upon todays date (i.e.
filename&todaysdate&.xls) then opens that same file, and does a few
basic formatting things to it in the background (i.e. removes all grid

please see...
http://www.excelforum.com/showthread.php?t=554259

I have read a few posts that come close but maybe some expert can offer a
more definitive solution here.  I have a drop down list in cell A6, it is in
the validation list of the cell.  I have a variety of pictures that I would
like to insert into that same worksheet when that ...

Can I set a Lookup formula in Excel to read data in an access table
using a macro?
What I'm after is for the user to put in a reference number in a cell
and the clients details to appear in an adjacent cell.  I know this is