• HOME
  • ABOUT
  • BASIC EXCEL
  • VBA TIP

FUNNY EXCEL

  • HOME
  • ABOUT
  • BASIC EXCEL
  • VBA TIP

VBA TIP

This is category share with you some tip about VBA in Excel. It’s will very useful and funny.

Example:

  1. What is vba?

  2. Split text string by delimiters

  3. Create database access from excel by vba

  4. Share add in HCaculator in word

VBA TIP

CODE VBA TO REMOVE ALL SHAPES QUICKLY IN EXCEL

by mrhonghat 08/08/201908/08/2019
by mrhonghat 08/08/201908/08/2019

Idea If you have an excel file and there are a lot of overlapping shapes, not beautiful, what will you do. As for me, I will think of some way…

0 FacebookTwitterGoogle +Pinterest
VBA TIP

SHARE ADD IN HCACULATOR IN WORD

by mrhonghat 07/08/201907/08/2019
by mrhonghat 07/08/201907/08/2019

Idea This article I will share about a very useful Add in. That’s caclulator in Ms Word. There may be similar Add in but it will be unique. The idea…

0 FacebookTwitterGoogle +Pinterest
VBA TIP

VBA CODE SHORT USD 1.000.000.000 INTO 1 BILLION-DOLLAR

by mrhonghat 03/08/201905/08/2019
by mrhonghat 03/08/201905/08/2019

Idea In fact, when making a report you may have trouble with very long data units. If you want to short it into a billion-dollar unit, you have to divide…

2 FacebookTwitterGoogle +Pinterest
VBA TIP

CREATE DATABASE ACCESS FROM EXCEL BY VBA

by mrhonghat 02/08/201902/08/2019
by mrhonghat 02/08/201902/08/2019

Ideas If you have learned about Excel, you will realize that Excel has a huge disadvantage. Specifically Excel 2010 is limited to 1.048.576 rows and 16.384 columns. So to solve…

2 FacebookTwitterGoogle +Pinterest
VBA TIP

SPLIT TEXT STRING BY DELIMITERS

by mrhonghat 01/08/201905/08/2019
by mrhonghat 01/08/201905/08/2019

If you need to split the string separated by delimiters as commas, colon, slash, dash or other delimiter quickly, let’s read the following article. First, I will take a example…

1 FacebookTwitterGoogle +Pinterest
VBA TIP

DIR FUNCTION IN VBA EXCEL

by mrhonghat 01/08/201905/08/2019
by mrhonghat 01/08/201905/08/2019

In VBA, there are many interesting functions with its specific functions. In this article, I will share about DIR function and some of its applications in practice. Dir function Returns…

2 FacebookTwitterGoogle +Pinterest
VBA TIP

WHAT IS VBA?

by mrhonghat 01/08/201901/08/2019
by mrhonghat 01/08/201901/08/2019

So what is VBA attractive? VBA or Visual Basic Application is a programming language in excel. Understandably, you can write the command line to do what you want in excel.…

4 FacebookTwitterGoogle +Pinterest

Recent Posts

  • CODE VBA TO REMOVE ALL SHAPES QUICKLY IN EXCEL
  • SHARE ADD IN HCACULATOR IN WORD
  • SHORTCUT KEY HELP YOU READ THE REPORT IN EXCEL
  • NUMBER FORMAT TRICK WITH THOUSANDS, MILLIONS AND BILLIONS WHEN USE COMMAS TO SEPARATE THOUSANDS
  • VBA CODE SHORT USD 1.000.000.000 INTO 1 BILLION-DOLLAR
  • CREATE DATABASE ACCESS FROM EXCEL BY VBA

@2019 - funyex.com. All Right Reserved. Designed and Developed by PenciDesign


Back To Top