Skip to content
This repository was archived by the owner on Sep 20, 2023. It is now read-only.

Installing-VBA.md

Latest commit

 

History

History
34 lines (22 loc) · 1.06 KB

Installing-VBA.md

File metadata and controls

34 lines (22 loc) · 1.06 KB
Raw

Installing main VBA module

The main VBA module file should be installed first

VBA Installation

  • Download COM_PORT_ENUMERATION.bas to a known location on your PC
  • Open a new Excel document
  • Enter the VBA Environment (Alt-F11)
  • From VBA Environment, view the Project Explorer (Control-R)
  • From Project Explorer, right-hand click and select Import File
  • Import the file COM_PORT_ENUMERATION.bas
  • Check that a new module COM_PORT_ENUMERATION is created and visible in the Modules folder
  • VBA6 only - delete PtrSafe keyword in function definition
  • Close and return to Excel (Alt-Q)
  • IMPORTANT - save document as type Macro-Enabled with a file name of your choice

Combo Box Creation

Use one of the two methods below to create and populate a Combo Box

  1. Supplied VBA subroutine

  2. Manual ComboBox Creation

Combo Box Testing