VBA | The learner Dede's Blog

EXCEL VBA: HOMEMADE EXCEL SHORTCUTS TO IMPROVE WORK EFFICIENCY

Nov 5, 2020 · 6 min read · Excel VBA homemade ·

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE I think there are quite a lot of cases to post text from Excel to …

EXCEL VBA: WITH POLYMORPHISM, BRANCHING A PROCESS WITHOUT USING IF STATEMENT

Nov 1, 2020 · 5 min read · Excel VBA HOMEMADE object-oriented ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE Hi, I'm Dede. Here I introduce a sample of coding based on a …

EXCEL VBA: I CREATED A TOOL THAT ALL SELECTED EXCEL BOOK HAVE THEIR CURSOR MOVED TO A1.

Nov 1, 2020 · 1 min read · Excel VBA HOMEMADE tool ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE This tool will free the user the hassle of having to move a …

ACCESS VBA: I CREATED A TOOL EXPORTING TABLE DEFINITIONS DISPLAYED AT DESIGN VIEW IN A TABULAR FORMAT.

Oct 27, 2020 · 2 min read · Access VBA HOMEMADE tool ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE This is a tool version of the export function described in the …

ACCESS VBA: I CREATED A FUNCTION EXPORTING TABLE DEFINITIONS DISPLAYED AT DESIGN VIEW IN A TABULAR FORMAT.

Oct 25, 2020 · 10 min read · Access VBA HOMEMADE ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE The options for exporting each table in MSAccess includes: Push …

ACCESS VBA: SOLUTIONS OF THE PROBLEM THAT AUTOMATIC COLUMN WIDTH ADJUSTMENT DOES NOT WORK WHEN USING USER-DEFINED FUNCTIONS IN THE CONTROL SOURCE.

Oct 13, 2020 · 6 min read · Access VBA ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE When using a datasheet type form in MSAccess, in case we assign a …

EXCEL VBA: I CREATED A QUOTATION CREATION TOOL.

Jul 16, 2020 · 2 min read · Excel VBA tool HOMEMADE ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE This article describes a Excel tool for creating a quotaion. You …

TOOL DEVELOPMENT ON EXCEL: COMPARING BETWEEN TOOLS USING FUNCTION (NON-MACRO) AND TOOLS USING VBA MACRO

Jul 16, 2020 · 3 min read · Excel VBA Excel Function ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE Let's assume you want to create tool by Excel that enables us to …