_vba-walkthrough-2-message-encryptor-and-decryptor.jpg "VBA Walkthrough #2: Message Encryptor and Decryptor from nested Video Screenshot Preview")
GalleryPlay Video:
(Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
⏲ Duration: 10 min 11 sec
✓ Published: 28-Jun-2012
✓ Published: 28-Jun-2012
Description:
This VBA macro is hopefully a bit more interesting than the last, and shows how I created a message encryptor/decryptor in Excel using VBA/macros.nnThe lesson covers these specific areas of VBA usage:nn- For...Next loop (including nested loops)nn- If...ElseIf...Then Statementnn- Excel functions: CHAR() / LEN()nn- VBA functions: Mod / Mid / Asc / ChrnnDownload the Message Encryptor & Decryptor here to follow along with the video lesson:nhttp://excelexposure.files.wordpress.com/2012/06/message
This VBA macro is hopefully a bit more interesting than the last, and shows how I created a message encryptor/decryptor in Excel using VBA/macros.nnThe lesson covers these specific areas of VBA usage:nn- For...Next loop (including nested loops)nn- If...ElseIf...Then Statementnn- Excel functions: CHAR() / LEN()nn- VBA functions: Mod / Mid / Asc / ChrnnDownload the Message Encryptor & Decryptor here to follow along with the video lesson:nhttp://excelexposure.files.wordpress.com/2012/06/message
Share with your friends:
Whatsapp | Viber | Telegram | Line | SMS
Email | Twitter | Reddit | Tumblr | Pinterest
_nested-udts.webp "Nested UDTs from nested")
_umbrella-foundation.webp "I had the pleasure of animating this logo for Rich Scott from Design A Bot. He is an extremely innovative logo designer. The Umbrella Foundation logo is for sale at brandstack.com (as of 12/09). Check out his portfolio here: http://brandstack.com/users/profile/designabotnThis logo was just crying out to be animated in this way. I think it came out pretty well.nnGeek stuff: There was around 120 particles that were nested together. I made the starting position all the same so they were grouped tog")
_ri-maya-realflow-arnold.webp "Some Research and Investigation on light scattering through liquids, in this example we can see how sss from alSurface works on milk, and some soft caustics working on cola from the jf_nested_dielectric material for Arnold")
_nested-sequence-59-mp4.webp "Nested Sequence 59.mp4 from nested")
_symbol-design-system.webp "View Presentation & Purchase: https://symboldesign.connSymbol is an advanced web-design system based on Sketch nested symbols. There are not only the components but also the logic, the atomic structure There are not only the components but also the logic, the atomic structure. You can easily change just one symbol to create your own design style super fast.nnSome features:nn- Easy to Customize. We spent a lot of time to make basic elements flexible and easy to customizablenn- Smart Typograph")
_drawers-organize-the-unity-launcher.webp "Drawers is a Ubuntu Linux utility for organizing related items for easy launching from the Unity Launcher. Drawers creates a favorite for the Unity Launcher that can contain any combination of files, applications, web links or directories. Just drop a file on the icon or open drawer and it will be added. Left-clicking the launcher")
_learn-programming-34-create-a-grid-of-objects-with-nested-while-loops.webp "We have seen in previous episodes how to create many objects at once using a while loop. This time we use a while loop inside a while loop to create a grid of objects. The result is a collection of objects (rectangles or circles in our example) distributed in the screen in a pattern similar to the white and black rectangles in a chess game.nUsing a loop inside a loop is something very common in programming, and we will see more examples in coming episodes.")
_in-the-flow-of-now-anon-i-mus.webp "“This moment is all there is and could ever be. There is never a time when it is not nested in the ‘Now’.Eternity is not a part of time; it is beyond the flow of linear time (the past and future).Living deeply in the present moment is like a rose flower that gently opens its petals (with no resistance) to the life-giving sun.-Anon I mus (Spiritually Anonymous)")
_nested-udts.jpg)
_umbrella-foundation.jpg)
_ri-maya-realflow-arnold.jpg)
_nested-sequence-59-mp4.jpg)
_symbol-design-system.jpg)
_drawers-organize-the-unity-launcher.jpg)
_learn-programming-34-create-a-grid-of-objects-with-nested-while-loops.jpg)
_in-the-flow-of-now-anon-i-mus.jpg)
![[+]](/images/menu.gif){kind=small}