VBA | The learner Dede's Blog

EXCEL VBA: THE MARCO TO COPY DATA TO MERGED CELLS

Feb 13, 2021 · 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 In Excel, when copying data from normal cells to merged ones, …

EXCEL VBA: YOU MAY HAVE A ERROR ON CHANGING PRINTAREA DYNAMICALLY & HOW TO AVOID IT

Jan 15, 2021 · 5 min read · VBA Excel ·

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 You may want your implementaion to change print area of a …

VBA: HOW TO USE ARRAYS AS A CLASS MEMBER WHEN USING INTERFACE INHERITANCE

Jan 13, 2021 · 3 min read · VBA 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 In VBA we can do object-oriented programming with interface …

VBA & POWERSHELL: THE TECHNIQUE TO EXTRACT A SPECIFIC STRING FROM MODULES, CLASSES OR SQL OF QUERIES IN ACCESS DATABASE

Dec 19, 2020 · 5 min read · Access VBA PowerShell 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 When creating a Access VBA tool, you may search and extract a …

EXCEL VBA: A MACRO TO SEARCH AND REPLACE A TEXT OF SHAPES IN EXCEL BOOK

Dec 11, 2020 · 5 min read · Excel 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 Hi, I'm Dede. Here I introduce a macro to search and replace a …

EXCEL VBA: TYPICAL PATTERNS FOR EXCEPTION HANDLING & SAMPLE OF HOW TO USE

Dec 5, 2020 · 12 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 In programming, it's a general implementaion to do special …

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 ·

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. 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 …