I am working on the following file in excel.
        A                         D
1   -40.07                    49085
2   -13,320.00              49086

I want to create a drop-down list (using Data, Validation, selecting
List...) but the drop--down list that opens will be dependant on the
value of another cell.
For example:

All dates are in column E but the data that i get has
9/1/2006
9/10/2006 odd due date this would be moved to column F.
and the due date in column E would be changed to 10/1/2006.

is it possible to programmatically assign a shortcut key to a macro? on close
for example?

I seem to hit a deadend in the following topic, but came across another
idea.
http://groups.google.com/group/microsoft.public.excel.programming/browse_thread/
thread/fcc8aae8002fde11/69ea9a0b49426a28?lnk=gst&q=Realmsteel&rnum=2#69ea9a0b494
26a28
What I am trying to do is make a merged ...

I have a spreadsheet that is being populated by external data. The data is
grouped together by company and between each company there are a couple of
blank lines to allow for the insertion of some code. I am looking for a way
to find the first blank line so I can add the formulas ...

I just finished writing some VBA code that will let me automatically refresh
the series of a chart (to account for more or less rows in the data set).  I
want to use this code in several XLS spreadsheets, but only want to maintain
one copy.

Hi guys, I've written some code that finds four letter words that don't
have repeating letters (ex: Foot wouldn't count, two O's) The problem
is that it takes a long time to generate them all. Below is my code, if
anyone wants to take a look at it and suggest performance tweaks ...

In addition to the previous post, I would like to be able to call a function
that resides in an add-in from a cell in a spreadsheet.
When I type: =FormatChart(yada, yada, yada....)
into a cell, the function seems to lock up.  One of the things about this

I am having trouble figuring out a way to go through a range and
determine if each cells date content was this week or last week etc,
What I have so far looks if it is equal to today but I want to change
it so it looks if the date is coming up within a week and I will have a

Dim checkbox1 As Boolean
   Worksheets("sheet3").ChartObjects(3).Activate
   ActiveChart.SeriesCollection(1).XValues = "=Sheet3!R3C1:R27C1"
   If checkbox1 = True Then

Hi I am getting frustrated with the code for the chart as below.
I want the chart series data source to change depending on a checkbox
linked to a cell. However I seem to have a problem with the line that
changes the values. (I recorded the original code from a macro). I have

I have this code which sets the max scale on a chart. If i type into to
the scale in the format axis box a number such as 0.013808 then my
chart scale updates. However if "p7" (as referred to in the code has a
value of 0.013808 my macro does strange things with my chart. (The

I've got a bit of code that scans through each cell in the first column
of a spreadsheet using the offset method looking for pagebreaks, and
inserting a new line and some text if it finds one. It takes about
20secs to do just 200 rows. I've set application.visible to false and

sheet1
       column A     column B
R1
R2      ABC                  10