Dropdown List Add New Feature Needed

[Gord Dibben]

Why are you directing your remarks to people who do not hang out here and
will never read your remarks?

As for me.............I just plonked you so I won't be reading your remarks
either.


Gord

 

[Patrick Molloy]

I'd not have mentioned not having the original mail if that had been there.
As it was I made the effort to find the original in Google and I responded
with what I had hoped was useful code.

to be honest, your tone is increasing aggressive

" The remark was OBVIOUSLY directed toward the MS AUTHORS, ya dope.
Use a little common sense."

Although this wasn't directed at me, for somebody such as myself and some
others that are trying to help, I'm actually starting to get just a little
ticked off.

You don't seem to be aware that those of us that respond do so freely of our
own time. We are not Microsoft employees, but do use Microsoft products,
specifically Excel in this ng, and we choose freely try to assist, through
this and other news groups anybody that has a problem.

 

[Mycelium]

Why are you directing your remarks to people who do not hang out here and
will never read your remarks?

As for me.............I just plonked you so I won't be reading your remarks
either.

Nice attempt at assistance, pussy. Oh, that's right... you made no
such attempt.

BTW, kill filter file edit session announcements are pretty petty and
lame, little boy. Grow up, Chuck, you make me want to upchuck.

 

[Mycelium]

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.

 

[Patrick Molloy]

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

 

[Mycelium]

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.

 

[Patrick Molloy]

on 4/7/2009 at 11:41 I replied with some code. Apart from you pissing 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]

on 4/7/2009 at 11:41 I replied with some code. Apart from you pissing 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?

What rude? and what aggression? "peanut gallery" is from the Mickey
Mouse Club days, so what is aggressive or rude about that?

Since the code you responded with was prior to you seeing the original
post, how could it be pertinent?

 

[Patrick Molloy]

What rude? and what aggression? "peanut gallery" is from the Mickey
Mouse Club days, so what is aggressive or rude about that?

Since the code you responded with was prior to you seeing the original
post, how could it be pertinent?

IF you'd even bothered to have read that, you'd have seen that I had taken
the trouble to find the original.

The issue is now closed.

 

[Mycelium]

IF you'd even bothered to have read that, you'd have seen that I had taken
the trouble to find the original.

The issue is now closed.

And after reading the original, you failed to answer the questions in
it. How quaint.

I do not recall asking for code. Particularly not some add line code
from some other table. The question was very specific. I suppose folks
post code snippets when they do not want to deal with the actual
questions asked.

There was no "issue" other than in your own mind. I am sure that you
are quite the legend there.

I would consider the term plural, and belonging to you. Issues.