programming

VBA: THE BENEFIT OF USING CLASS AND THE WAY TO USE, WITH A SIMPLE SAMPLE PART 2

Nov 22, 2020 · 9 min read · Excel VBA HOMEMADE object-oriented ·

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. This article is a a sequel of a article I posted …

VBA: THE BENEFIT OF USING CLASS AND THE WAY TO USE, WITH A SIMPLE SAMPLE PART 1

Nov 20, 2020 · 6 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 Class in VBA is kind of minor and somehow hard-to-use than any …

Access VBA: A SIMPLE SAMPLE OF INSERTING AND DELETING A RECORD ON A SUBFORM

Nov 15, 2020 · 1 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 This articel demonstrates a sample which uses subform and inserts …

Access VBA: THE THING YOU NEED TO BE AWARE OF WHEN CREATING EVENT LISTENER BY USING WITHEVENTS FOR FORM CONTROLS

Nov 8, 2020 · 6 min read · Access 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 I tried to create a event listener class by using WithEvents …

EXCEL VBA: HOMEMADE EXCEL SHORTCUTS TO IMPROVE WORK EFFICIENCY

Nov 5, 2020 · 6 min read · Excel 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 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 …