VBA Excel Data Send Keys Help

Dear Experts Please Guide me With Best Solution i Have Problem i have to Paste Following Text Using Call SendKeys("cba123++", True) and you know "+" use in Send key for shift so send key recognize "+" Sign so it show compile error 5 while i have use Chr(43) function for the input of special character "+" but its not working i also also tried to paste it through calling from sheet range but same error and not working please guide solution and oblige Regards,
WiseOwl ExcelAsked:
Who is Participating?
Dustin SaundersConnect With a Mentor Director of OperationsCommented:
You should be extremely careful about using SendKeys...  can lead to all sorts of problems.

But to answer your question, the + signs have to be in curly braces if you want to use it.

SendKeys "cba123{+}{+}"

Open in new window

NorieVBA ExpertCommented:
Where do you need to paste to and why do you need to use SendKeys?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.