The learner Dede's Blog

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 …

WINDOWS10'S VIDEO RECORDING APP CAN'T RECORD FORMS OF EXCEL AND ACCESS. ABOUT IT WE SHOULD ...

Nov 15, 2020 · 1 min read ·

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 Windows10 has a video recording app named Game Bar, and we can …

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 …

POWERSHELL: THE WAY TO GET THE PATH LIST OF THE FILES WHICH HAVE BEEN UPDATED SINCE [SPECIFIED TIME].

Oct 30, 2020 · 2 min read · Powershell ·

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 had a occation of working on a different PC (Windows) than …

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 …