Are you deleting the bad entry via F2 and deleting the entry?

I have no problem with that method in 2003

i.e. select one then two then three from List in C3 to get one, two, three
in D3

Oops! don't want the "two" so F2 then delete the ",two".

Go back to dropdown and select four

I now have one, three, four in D3


Gord Dibben MS Excel MVP

On Wed, 7 Jan 2009 22:14:32 +0000, ukusprof
wrote:


Hi folks- New to the forum and to VBA and I need some help. I too have
downloaded the DataValMultiSelect.zip and can get it to work fine to ADD
selections. However, when I try to delete one or more of the selections
(e.g., added one by error or changed my mind), it simply adds that
choice again, rather than deleting.

Can someone help me with how to add mutliple selection capability along
with cell editing capability?

Many thanks in advance- Really need an answer on this one!

A. Stringer