Martin Liss
Keep everyone healthy; Get Vaccinated
  • San Jose,
  • California,
  • United States of America
Member Since: 1999/11/30
Industry: Consulting
Top Skills:
Tech Certifications:
View All
CERTIFIED EXPERT
  • Topic Advisor

Almost 50 years of programming experience. Click '+ More' in my "Full Biography" to see links to some articles I've written.

More bio
Activity
Points this month15,960
Total points11,785,535
Questions: 104
Solutions: 4994
Articles: 25
Videos:
Tutorials:
Posts: 2
Group Discussions: 118
Live: 1
Full Biography

Almost 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

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 76
Martin needs 72,465 points to level up.
LVL 77
  • Overall
    76
  • Microsoft Excel
    67
  • Microsoft Office
    57
  • VBA
    54
  • Visual Basic Classic
    33
  • VB Script
    18
  • Microsoft Applications
    17
  • Spreadsheets
    11
  • Programming
    10
  • Microsoft Access
    9
  • Microsoft Word
    8
  • Outlook
    7
  • Visual Basic.NET
    7
  • Microsoft 365
    6
  • Office Productivity
    6
  • Mac OS X
    5
  • Microsoft Development
    5
  • Windows OS
    5
  • Programming Languages-Other
    4
  • Scripting Languages
    4
  • .NET Programming
    4
  • Apple OS
    3
  • Microsoft SQL Server
    3
  • Software
    3
  • Windows 10
    3
  • Experts Exchange
    3
  • Apple Software
    3
  • Windows 7
    3
  • R
    3
  • SQL
    3
  • XML
    3
  • Microsoft
    3
  • Miscellaneous
    3
  • Microsoft Legacy OS
    3
  • Statistical Packages
    2
  • ASP
    2
  • Databases
    2
  • Office Suites-Other
    2
  • Web Browsers
    2
  • Math / Science
    2
  • PC
    2
  • Security
    2
  • Windows XP
    2
  • Power BI
    2
  • Microsoft SQL Server 2008
    2
  • C#
    2
  • Microsoft SharePoint
    2
  • Apple Hardware
    2
  • OneDrive
    2
  • Google Workspace
    2
  • Powershell
    2
  • Exchange
    2
  • Storage
    2
  • Operating Systems
    2
  • Desktops
    2
  • Storage Hardware
    2
  • Golang
    2
  • Networking
    1
  • VMware
    1
  • Email Software
    1
  • Fonts Typography
    1
  • JavaScript
    1
  • Web Development
    1
  • Disaster Recovery
    1
  • COBOL
    1
  • Storage Software
    1
  • Virtualization
    1
  • Images and Photos
    1
  • PDF
    1
  • ASP.NET
    1
  • Microsoft Visual Studio
    1
  • Microsoft PowerPoint
    1
  • Printers and Scanners
    1
  • Crystal Reports
    1
  • Regular Expressions
    1
  • Hardware
    1
  • Installation
    1
  • Swift Programming
    1
  • iPhone
    1
  • Exclaimer
    1
  • Microsoft Server OS
    1
  • Windows Batch
    1
  • Programming Theory
    1
  • Google
    1
  • Email Servers
    1
  • Chrome
    1
  • REST
    1
  • Active Directory
    1
  • Internet Protocols
    1
  • Remote Access
    1
  • Facebook
    1
  • Adobe Acrobat
    1
  • Laptops Notebooks
    1
  • Algorithms
    1
  • Visual C++.NET
    1
  • FTP
    1
  • SSRS
    1
  • HTML
    1
  • File Sharing Software
    1
  • Windows Networking
    1
  • Productivity Apps
    1
  • Quality Assurance
    1
  • Shell Scripting
    1
  • Microsoft Visio
    1
  • Node.js
    1
  • AutoHotkey
    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
  • Oracle Database
    1
  • Peripherals
    1
  • Project Management
    1
  • Web Graphics Software
    1
  • Wireless Networking
    1
  • iOS
    1