on 4/7/2009 at 11:41 I replied with some code. Apart from you ****ing off me
and my colleagues, i saw no response.

lets have a little less of the rude aggression and such - all I have been
doing is trying to help here, OK?



"Mycelium" wrote in
message ...
Well, it would have been outstanding had you made even a meager attempt
to answer the questions. The OP was quoted to facilitate that, but you
seem to be in peanut gallery comment mode lately.


On Thu, 9 Jul 2009 09:29:29 +0100, "Patrick Molloy"
wrote:

so after all this, is this topic closed or is there something outstanding?

"Mycelium" wrote in
message ...
On Sat, 4 Jul 2009 10:49:12 +0100, "Patrick Molloy"
wrote:

as far as I can see, your original post, at 03:07 on 02/07/2009
has one word in the body.
That word is "WHY".
The subject "Dropdown List Add New Feature Needed" doesn't describe the
problem


It does if you actually reference the original post. There are a few
simple questions, and one that could get more complex if *we* (myself
and
the assistant) were to tackle the scenario.



Quoted As follows from 6/26/2009:

Hi folks.

How can I create a button or list entry that takes the user to a cell to
add a "new item" or "new user" to a dropdown list array by way of row
insertion and cursor placement... that takes the last entry in the
existing drop down list to use as an "add new" "button" or trigger?

The event is to add a new row to an existing named array, which
automatically updates all code in the workbook, if the row is inserted
from within the existing array.

So the last entry in the drop down list array could (would) be an "Add
New" selection for the user to choose. When the fill is performed, the
action could be to test that cell content and act accordingly. The user
would get switched to the array with the cursor in the left most cell of
the newly inserted row. This also has the effect of keeping the cell
formatting as well for solid color arrays, that is.

Is this possible? I suppose a test loop that tests the cell content,or
one that tests for and grabs the content even before it makes it to a
cell. Anyway, when one selects the add new selection from the drop down
list, instead of filling that data into the cell, it performs the insert
and pop over function so that a new record can be added.

I have a sheet that has about eight small,named arrays on it and use it
as a master data sheet for a 'presentation' type sheet that draws much
of
its data from lookups to the array sheet.

A simple row insertion on that sheet updates all arrays, etc. in the
entire workbook. Nice job, guys. I LIKE IT!

So, anyway, is this a good approach for expanding the contents of an
array? Is keeping all these arrays on a single sheet a good approach?
This is like yet another new form of a database configuration, in the
final analysis. Thanks for any thoughts or views.

At least one inquiring mind wants to know.

End Quoted post


So there are actually a few easy questions there, and it was passed over
several times.