{"id":12088,"date":"2024-02-02T21:03:46","date_gmt":"2024-02-02T21:03:46","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=665"},"modified":"2024-02-02T21:03:46","modified_gmt":"2024-02-02T21:03:46","slug":"vba-reverse-a-string","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-reverse-a-string\/","title":{"rendered":"VBA: Reverse a string"},"content":{"rendered":"
It is very easy to get the Reverse of a string entered by user in Excel VBA by using VBA inbuilt functionality. strReverse()<\/strong><\/span> is the inbuilt function which returns reverse of the String given as input to this function.<\/p>\n Syntax:<\/strong><\/p>\n Returned Value:<\/strong> It returns a reversed string of your given input String.<\/em><\/p>\n Example:<\/strong>Below code will return the Reverse of the String, entered in to A1 Cell in to B1 Cell, on clicking on the CommandButton1.<\/i><\/p>\n It is very easy to get the Reverse of a string entered by user in Excel VBA by using VBA inbuilt functionality. strReverse() is the inbuilt function which returns reverse of the String given as input to this function. Syntax: strReverse(“Your Input String”) Returned Value: It returns a reversed string of your given input String. […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1246,1678,1682],"tags":[],"class_list":["post-12088","post","type-post","status-publish","format-standard","hentry","category-macro","category-interesting-vba-functions","category-popular-articles"],"yoast_head":"\nstrReverse(\"Your Input String\")<\/code><\/p>\n
\nPrivate Sub CommandButton1_Click()\nRange(\"B1\").Value = StrReverse(Range(\"A1\").Value)\nEnd Sub\n\n<\/code><\/pre>\n<\/span>","protected":false},"excerpt":{"rendered":"