Make a backward message by reversing the entire order of values in cell?

This is a useless whimsical concept. For those still reading: Would it be possible to create a macro that would reverse the order of the string values inside a cell?

For example if cell "A1" contained: "A backwards message." then running this macro would cause the cell value to change to: ".egassem sdrawkcab A".

Hi

Have fun

Please Login or Register  to view this content.

rylo

StrReverse function should do what you are after.

Please Login or Register  to view this content.

Originally Posted by jindon

StrReverse function should do what you are after.

Please Login or Register  to view this content.

But wont I have to hard code the string inside VBA?

Thank you rylo!

(I use Option Explicit in my modules so I had to add the following lines to your code:

Please Login or Register  to view this content.

)

Not at all.

You can reference cells or variable or what ever you want.
e.g
Range("a1").Value
ActiveCell.Value
etc.

Please Login or Register  to view this content.

Originally Posted by jindon

Not at all.

You can reference cells or variable or what ever you want.
e.g
Range("a1").Value
ActiveCell.Value
etc.

Please Login or Register  to view this content.

Sorry Jindon. I wasn't thinking. You are right. Thanks for the help.

Originally Posted by mc84excel

Sorry Jindon. I wasn't thinking. You are right. Thanks for the help.

No problem.

If you want toggle. just change to

Please Login or Register  to view this content.

Thank you all for your assistance in solving this thread.

I am pleasantly surprised at the amount of help received for something that is of no practical use. If you enjoyed this whimsical vba challenge and are interested in another, check out: http://www.excelforum.com/excel-prog...on-ribbon.html