Martin Liss
Social distance - Don't touch your face - Wash your hands for 20 seconds
  • United States of America
Member Since: 1999/11/30
Industry: Marketing
Top Skills:
Tech Certifications:
View All
CERTIFIED EXPERT
  • Cleanup Volunteer
  • Topic Advisor

Over 40 years of programming experience. Expand my "Full Biography" to see links to some articles I've written.

More bio
Activity
Points this month54,384
Total points8,588,158
Questions: 74
Solutions: 3971
Articles: 24
Videos:
Courses:
Posts:
Group Discussions: 118
Live: 1
Full Biography

Over 40 years of programming experience in various languages including COBOL, APL and Visual Basic for 20 or so 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 - 2017

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 blue and white ‘Good Article?’ button at the bottom of the article. Thanks:)

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

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

Apple OS X
-----------------------------
An Experts Exchange Shortcut for the Truly Lazy:  https://www.experts-exchange.com/articles/22719/An-Experts-Exchange-Shortcut-for-the-Truly-Lazy.html

Community
-----------------------------
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

More
Languages
English
Native or Bilingual Proficiency
Visual Basic Classic
Full Professional Proficiency
VBA
Full Professional Proficiency
Professional Background
Senior Programmer
IBM/Siemens
January 2001 – May 2003
San Jose, CA
Senior Programmer and later Programming Manager
Rolm
August 1980 – January 2001
Santa Clara, CA
Programmer
Datapoint
January 1980 – August 1980
Silicon Valley
Programmer
Diablo Data Systems
June 1979 – August 1979
Silicon Valley
Programmer
Xerox
July 1973 – June 1979
Rochester NY
Began Xerox full-time, in-house, programmer training December 1973. Graduated May 1974.
More
Education
Xerox: full-time, in-house, programmer training
Programming
1973 – 1973
Programming concepts and languages: BASIC, Fortran, Cobol and APL
Syracuse University  
Organic Chemistry
More

Level Progress

Current: Level 65
Martin needs 123,842 points to level up.
LVL 66
  • Overall
    65
  • Microsoft Excel
    55
  • Microsoft Office
    43
  • VBA
    43
  • Visual Basic Classic
    31
  • VB Script
    17
  • Microsoft Applications
    17
  • Spreadsheets
    10
  • Programming
    9
  • Microsoft Access
    9
  • Microsoft Word
    8
  • Outlook
    6
  • Visual Basic.NET
    6
  • Office Productivity
    5
  • Microsoft Development
    5
  • Mac OS X
    5
  • Microsoft 365
    4
  • Programming Languages-Other
    4
  • Windows OS
    4
  • Scripting Languages
    3
  • .NET Programming
    3
  • Software
    3
  • Apple OS
    3
  • Microsoft SQL Server
    3
  • Query Syntax
    3
  • XML
    3
  • Microsoft Legacy OS
    3
  • Windows 7
    2
  • Office Suites-Other
    2
  • ASP
    2
  • Miscellaneous
    2
  • Windows XP
    2
  • Databases
    2
  • Web Browsers
    2
  • Power BI
    2
  • Security
    2
  • Microsoft SQL Server 2008
    2
  • Experts Exchange
    2
  • Windows 10
    2
  • Apple Hardware
    2
  • Apple Software
    2
  • PC
    2
  • Exchange
    2
  • Operating Systems
    2
  • Math / Science
    1
  • VMware
    1
  • Powershell
    1
  • R
    1
  • SQL
    1
  • Email Software
    1
  • COBOL
    1
  • Virtualization
    1
  • Storage
    1
  • Google Apps
    1
  • Storage Hardware
    1
  • Swift Programming
    1
  • iPhone
    1
  • Exclaimer
    1
  • C#
    1
  • Golang
    1
  • Microsoft Server OS
    1
  • Crystal Reports
    1
  • Programming Theory
    1
  • Desktops
    1
  • Regular Expressions
    1
  • Windows Batch
    1
  • Web Development
    1
  • Fonts Typography
    1
  • Google
    1
  • PDF
    1
  • Storage Software
    1
  • Email Servers
    1
  • Chrome
    1
  • REST
    1
  • Active Directory
    1
  • Facebook
    1
  • Adobe Acrobat
    1
  • Images and Photos
    1
  • Microsoft PowerPoint
    1
  • Algorithms
    1
  • Visual C++.NET
    1
  • FTP
    1
  • Microsoft
    1
  • SSRS
    1
  • HTML
    1
  • Windows Networking
    1
  • Statistical Packages
    1
  • Shell Scripting
    1
  • Microsoft Visual Studio
    1
  • ASP.NET
    1
  • Hardware
    1
  • JavaScript
    1
  • Disaster Recovery
    1
  • Acronis
    1
  • Adobe Creative Suite CS
    1
  • C
    1
  • Components
    1
  • Delphi
    1
  • Document Management
    1
  • Illustration Software
    1
  • InfoPath
    1
  • Lotus IBM
    1
  • Microsoft Dynamics
    1
  • Microsoft SharePoint
    1
  • Oracle Database
    1
  • Peripherals
    1
  • Project Management
    1
  • Web Graphics Software
    1
  • Wireless Networking
    1
  • iOS
    1