Hello,
I have been using Excel VBA to access a com port and do some functions with. Usually I have to find out what my port is and type the number in a cell, and my code takes it from there.
Is there a way to have a combobox that when it is dropped down, to list the available com ports for me to choose? Then I could select the com port I am using and let my code run with that. That way I wouldn't have to go into device manager to see what I have already.
Any help or direction would be greatly appreciated.
Thank you in advance
I have been using Excel VBA to access a com port and do some functions with. Usually I have to find out what my port is and type the number in a cell, and my code takes it from there.
Is there a way to have a combobox that when it is dropped down, to list the available com ports for me to choose? Then I could select the com port I am using and let my code run with that. That way I wouldn't have to go into device manager to see what I have already.
Any help or direction would be greatly appreciated.
Thank you in advance