Simple program to learn from excel

Tweet

Hello all - Sometimes we received a coded text from friends wherein it is written in a reverse text. ie; "mylot" will be written as "tolym". Do you know that you can create your own coded words like this? Yeah, my favorite is using excel but there are other application also, but I prefer excel since it is a common application. If you want to learn something, follow these steps; 1) Open blank excel application 2) Type any text or words in range A1 3) Hit Alt + F11, to open the Visual Basic Environment 4) From the left side,you can see VBAProject(Book1), right into it and insert Module 5) A large white screen appears to the right side 6) Write sub mycode and press enter key the screen automatically looks like this [b]Sub mycode() End Sub[/b] 7) After the line Sub mycode(),write this code; [b1].Value = StrReverse([a1].Value) 8) Close the Visual Basic Environment by clicking on the x button to the right or hit Alt + q 9) Click on Tools Macro Macros and double click mycode or click run button and hey, you have the coded words or text in range B1. Good luck. Happy excelling.