Do you want to be part of my Next article?? … Here you go…

.

Dear Readers,

In my next article, which will be published next Monday, I am going to cover following two topics:

  • 5 Interesting but rarely used features/functions in Excel/Excel VBA
  • 5 Interesting facts about Excel [from history…]
  • Before I publish these articles, I thought to check what all interesting facts and functions you already know about Excel and Excel VBA? This count of 5 might increase… way more than that.

    So, now you know that this article is bit different than others articles. Here, I am not teaching anything, rather I am going to learn something from you.

    If interesting facts provided by you is really interesting ;), then I will include them in my article — and provide credit to you [Do not forget to read the Note section below].

    So let’s make this list as big/complete as we can.

    So, What You need to do?

    It’s simple… type the interesting function, feature, facts you know about Excel/Excel VBA in the comment section or on facebook page or on twitter.

    Note: Do not forget to provide your website URL/ profile page or any link which you want me to link it to against your provided interesting features.

    Count down starts now…

    So you have got one week of time to send… whatever interesting facts/features you know about Excel/Excel VBA…

    Count Down Starts Now

    Count Down Starts Now

    Buy a coffee for the author

    Adsense

    Download FREE Tools and Templates

    There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.

    Dynamic Arrays and Spill Functions in Excel: A Beginner’s Guide
    Dynamic Arrays and Spill Functions in Excel: A Beginner’s Guide

    In today's tutorial, we'll be diving into the exciting world of dynamic arrays and spill functions in Office 365 Excel. These features have revolutionized the way we work with data, providing a more flexible and efficient way to handle arrays. I am going to explain...

    How to Declare a Public Variable in VBA
    How to Declare a Public Variable in VBA

    While programming in VBA sometimes you need to declare a Public Variable that can store the value throughout the program. Use of Public Variable: Let's say you have 4 different Functions in your VBA Code or Module and you have a variable that may or may not be...

    How to Copy content from Word using VBA

    As many of us want to deal with Microsoft Word Document from Excel Macro/VBA. I am going to write few articles about Word from Excel Macro. This is the first article which opens a Word Document and read the whole content of that Word Document and put it in the Active...

    What is Excel Formula?

    Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).

    You May Also Like…

    5 Comments

    1. Martin

      I would like to connect to the AS400 to download with an SQL 400 statement data in a excel spread sheet.

      Reply
    2. Krishnaprasad Menon

      Hi
      i have been using Excel for last 23 years and one of my favourite topic is Excel Macros. I have explored various possibilities of VBA Macros and it fueled my imagination and creativity in the field of Animation. Animation is actually nothing but an illusion of changing frames of an object or view in a pre arranged sequence. It is the same principle used in a different way in a movie. Scientifically, human brain and eyes can process only 10-12 images per second and such images are retained for a few more fractions of a second. When another image in a continuing sequence replaces this vision, it creates an illusion of continuity. Film theorists call this illusion as persistance of vision. Futher, I thought, if macros can display objects, shapes and pictures, make them hidden, re-display at the required positions on the screen, how can i use it to create some animated movements. In Excel, pictures, images and shapes can be displayed, moved and hidden with VBA programming. My efforts lead me to explore various possibilities and more learining. i have taken a course from Udemy on Excel Animation and my first teacher in this area was Mr.Kishon Deori. Learnings from him mixed with my own research and efforts gave me more ideas to create moving objects on the screen. I had used various photo sequences freely available on the net to create some flying birds, running tigers etc. Slowly, i have learned the tricks of editing sound files and using it in the macros to activate it when a related frame is projected on the screen. I have experimented with flying birds and playing their chirping sounds, moving clouds coupled with thunders, running tigers with roaring sounds and like. With my continuous efforts, i could create an animated micro movie named “Beautiful Nature” projecting Sun rise, flying birds, flying aeroplane, moving rainy clouds, lightning and thunders. I have included scenes of moon rising, twinkling stars, clouds covering the moon and tigers running atop a mountain in the pitch dark night coupled with appropriate sound files. My efforts were very much appreciated by Mr.Kishon Deori.

      Reply
    3. Allyn Kahn- Suncoast Chess

      Hi I have been using VBA Excel for about 8 years.

      I would like to see VBA that does these two things:
      1. VBA code that uses a loop to fill an Excel Table with numerical data take from a two- dimensional Array

      2. Same as above for an ACCESS TABLE

      Reply
      • Vishwamitra Mishra

        Thanks Allyn for stopping by. I would try to write an article on this sometime in future. By the way the next article was mainly about the interesting/hidden/rarely used features you want to share. If you have one, you can share it.

        Reply

    Submit a Comment

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Join and get a FREE! e-Book

    Don't miss any articles, tools, tips and tricks, I publish here

    You have Successfully Subscribed!

    Pin It on Pinterest