Hi,
I have a set of data whereby I have some VBA code in it where it will take text in a box and capitalize the first letter of each word. I now want to take that text and wherever the words 'click here' or 'click here now' are present in the text, I want to make them all capitals. As an example:
To Learn About Excel Click Here Now!
would automatically become:
To Learn About Excel CLICK HERE NOW!
Or:
To Learn About Excel Click Here!
would automatically become:
To Learn About Excel CLICK HERE!
I am not sure how to code this into the sheet. I have attached an example (Excel 2007) and appreciate any help
Will
Changing this one line should work.
Target = Replace(Replace(StrConv(Target, vbProperCase), "Click Here Now", "CLICK HERE NOW"), "Click Here", "CLICK HERE")
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Brilliant Mike, thanks so much, works perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks