Translate

Showing posts with label VBA. Show all posts
Showing posts with label VBA. Show all posts

Thursday, April 13, 2017

6 Ways: Unique List of items from Multiple entries



Objective
You have some data where a particular field has many items occurring repeatedly and you need a list of unique items only like from (A,B,A,C,D,E,F,F,E,C,B,A,D) you need (A,B,C,D,E)


Monday, February 27, 2017

VBA Basics / My First Steps to Programming (Lesson 1)


Objective
Understand what is Visual Basic, how it is embedded in Office applications, what it can do and basic idea of using it.


Friday, February 17, 2017

How to Show Progress Bar in Excel / Macro


Objective
Like modern software, while your Macro/code is rendering a time consuming service, a percentage completion status should be shown to the user.