Almost 50 years of programming experience. Click '+ More' in my "Full Biography" to see links to some articles I've written.
More bioAlmost 50 years of programming experience in various languages including COBOL, APL and Visual Basic for more than 30 years.
Microsoft MVP 2009 - 2017 (VB6 2009 - 2016, Excel 2017)
Experts Exchange MVE 2015 and 2017
Experts Exchange Distinguished Expert in Excel 2018
Experts Exchange Top Expert Visual Basic Classic 2012 - 2020
Experts Exchange Top Expert VBA 2018 - 2020
While I prefer to answer questions on this site, you can reach me at Gmail by writing to MartinHLiss (Note the 'H'). You can also contact me at that email address if you'd like to discuss having me do freelance programming for you in VB6 or Excel VBA.
The following are articles that I've written. If you find them useful then please click the 'thumbs up' icon at the bottom of the article. Thanks:)
VBA
--------------------------
My Favorite Code Snippets:
https://www.experts-exchange.com/articles/31877/My-Favorite-Code-Snippets.html
Quickly and Easily Copy Shapes and Their Assigned Macros to a New Location:
https://www.experts-exchange.com/articles/31672/Quickly-and-Easily-Copy-Shapes-and-Their-Assigned-Macros-to-a-New-Location.html
The magical floating ActiveX control:
https://www.experts-exchange.com/articles/12362/The-magical-floating-ActiveX-control.html
Creating your own Excel formulas and doing the impossible:
https://www.experts-exchange.com/articles/20559/Creating-your-own-Excel-Formulas-and-doing-the-impossible.html
Deleting Shapes - A warning:
https://www.experts-exchange.com/articles/29629/Deleting-Shapes-A-Warning.html
Custom Document Properties in Excel:
https://www.experts-exchange.com/articles/29697/Custom-Document-Properties-in-Excel.html
VBA & VB6
--------------------------
The Case for Select Case:
https://www.experts-exchange.com/articles/31766/The-Case-for-Select-Case.html
Using the Debugger:
https://www.experts-exchange.com/articles/8631/Debugging-VBA-and-VB6-Applications.html
Documenting changes to VB6 or VBA code:
https://www.experts-exchange.com/articles/11093/Documenting-changes-to-VB6-or-VBA-code.html
Using Enums in VB6 and VBA:
https://www.experts-exchange.com/articles/9669/Using-Enums-in-VB6-and-VBA.html
Automatic Insertion of Procedure Names in VBA and VB6 Code:
https://www.experts-exchange.com/articles/8634/Automatic-Insertion-of-Procedure-Names-in-VBA-and-VB6-Code.html
A Textbox ActiveX Control That Limits Input to Numbers:
https://www.experts-exchange.com/articles/8635/A-Textbox-ActiveX-Control-That-Limits-Input-to-Numbers.html
Spell Check a Textbox:
https://www.experts-exchange.com/articles/8678/Spell-check-a-VBA-or-VB6-ActiveX-textbox.html
How to Time Code:
https://www.experts-exchange.com/articles/10592/How-to-Time-Code.html
A Guide to Writing Understandable and Maintainable VBA Code:
https://www.experts-exchange.com/articles/21759/A-Guide-to-Writing-Understandable-and-Maintainable-VBA-Code.html
How to store data of different types in the same array:
https://www.experts-exchange.com/articles/23399/How-to-store-data-of-different-types-in-the-same-array.html
A Game of Draw Poker:
https://www.experts-exchange.com/articles/29698/A-Game-of-Draw-Poker.html
VB6
--------------------------
Conditional Compilation:
https://www.experts-exchange.com/A_8809.html
Dynamically Resize Form Controls:
https://www.experts-exchange.com/articles/8850/Dynamically-Resize-Form-Controls.html
Simple games:
https://www.experts-exchange.com/articles/9009/Simple-Games.html
Mac
--------------------------
An Experts Exchange Shortcut for the Truly Lazy:
https://www.experts-exchange.com/articles/22719/An-Experts-Exchange-Shortcut-for-the-Truly-Lazy.html
Experts-Exchange
--------------------------
Determine your Experts-Exchange Rank:
https://www.experts-exchange.com/articles/33770/Are-you-aware-that-you-have-an-Experts-Exchange-Rank.htm
Improved EE Formatting Tags:
https://www.experts-exchange.com/articles/8690/Improved-Formatting-Tags.html
Use Google Translate to Improve Your Questions and Answers:
https://www.experts-exchange.com/articles/30723/Use-Google-Translate-to-Improve-Your-Questions-and-Answers-Sigue-una-versi-n-en-espa-o.html
Are you aware that you have an Experts Exchange Rank?:
https://www.experts-exchange.com/articles/33770/Are-you-aware-that-you-have-an-Experts-Exchange-Rank.html