Functions to determine com ports available on host PC and allow user to select one for subsequent use via a Worksheet or Ribbon combo box.
Drop-down click will refresh query to update combo box with any newly added or removed com ports since last selection.
Excel Worksheet VBA and Combo instructions here
Excel Ribbon VBA and Combo instructions here
