correct two code merged to move data from listbox and paste to other cell only value

[mazan2010]

Dear All
can help me to know what the wrong in this code
i the following code from two code that want to transfer data from listbox then copy data from two column to another two column with value only

the problem in the following row

[karmapala]

Regardless to the rest of the code ....

Please Login or Register  to view this content.

I think that is not a correct syntax

it should be like this:

Please Login or Register  to view this content.

you need to add "L" for "xl" .

[mazan2010]

thank you so much for your notes i find the mistake
the coorrect one is

its missed l

[mazan2010]

thank you

[karmapala]

you're welcome .

Just for you guidance,
you will notice that if it's not a correct syntax, excel won't correct it to upper/lower case letters.

So, next time when you see all the letters in your syntax still in lower-case (just like xpastevaluesandnumberformats),
then mostly because it's not a correct syntax. So then you know something wrong with the syntax.

Say, you write all in lowercase : xlpastevaluesandnumberformats
once you go for the next line, Excel will put correct it to upper/lower case : xlPasteValuesAndNumberFormats

[mazan2010]

really its great info , first time know this , thank you so much for your help and teaching me this