Multiple selection from and into validated cell.
 

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


--
ukusprof
------------------------------------------------------------------------
ukusprof's Profile: http://www.thecodecage.com/forumz/member.php?userid=85
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=11091

Multiple selection from and into validated cell.
 

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

Multiple selection from and into validated cell.
 

Apologies. Wrong sheet.

You must be using the sheet code for entries in the same cell.

I see what you mean.

I guess the code could be altered but no time right now.

Will look at it later.


Gord


On Thu, 08 Jan 2009 10:37:01 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

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

Multiple selection from and into validated cell.
 

No problem, Gord! Thanks so much for your help. As I'm sure you saw, in
same cell, using the F2 method returns an validation error message.

When you (or anyone) gets time, it would help me (and probably others)
tremendously to add this functionality to drop down lists!

Many, many thanks-

Allison

Gord Dibben;174238 Wrote:
Apologies. Wrong sheet.

You must be using the sheet code for entries in the same cell.

I see what you mean.

I guess the code could be altered but no time right now.

Will look at it later.


Gord


--
ukusprof
------------------------------------------------------------------------
ukusprof's Profile: http://www.thecodecage.com/forumz/member.php?userid=85
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=11091