Adding extra case to macro...

[mmcgrail]

Hi, i have this code that works on the basis of people entering information.
I just want to add more cases similar to case 11 but depending on what is typed in?

thanks, and if anybody wants more info, please ask
Michael

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

[mmcgrail]

such a small addition, thanks very much.
btw is there anything that you can but in the -value = "john"- part that would mean anything else written do this?

Thanks

[patel45]

i'm sorry, english is not my langage, can you explain in other words ?

[mmcgrail]

So if I had a cell that you could write "blue" in it would move that row, and if you wrote "red" it would move it somewhere else...
So if someone wrote yellow or green or anything else neither would happen...

So is there something that can be put so if it meets none of the above options it does something else like a msg box to tell you the only options are red or blue

[patel45]

Please Login or Register  to view this content.

[HaHoBe]

Hi, mmcgrail,

your chosen example differs a lot from the code you supplied in the Opening Post - I think you would like to keep the other checks as well:

Please Login or Register  to view this content.

Ciao,
Holger

[mmcgrail]

Hi, yeah I was trying to explain it more easily...but obviously haven't...

Yes I would like the other checks but if someone enter something that wasn't in the above cases then to show a message box saying so...

[HaHoBe]

Hi, mmcgrail,

like this?

Please Login or Register  to view this content.

Ciao,
Holger

[mmcgrail]

thats it! Im amazed that i didnt work that out myself!

thanks very much Holger