VBA to check if data in clipboard has "£" in it.

[pvuv]

hello,
i have an excel based order managemnt system where i copy orders from a CSV file and paste it in Excel worksheet. I need a macro to check the data before pasting it in "Sheet1" for "£" sign and if found give an error saying "data not suitable". if this error needs a userform type box i will be more than happy to create one.

i have other worksheets in this excel workbook where i paste data that has "£" sign so i only need it to come in effect when pasting data in Sheet1.
Also i will be combining the VBA with an existing macro which formats and amends the pasted data so a macro will be helpful which i can paste in my existing macro.

my current macro starts like this:
' PROCESS2 Macro
'

'
Range("A1").Select

(i am assuming i can just paste your vba code before the line range ("A1") select.
many thanks for your help in this matter

[pjwhitfield]

Assuming you have your data in a string then

Please Login or Register  to view this content.