Click here to Skip to main content
15,944,136 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
In previous version of Excel I been able to read data from the comport using Excel and VBA.
When doing that I added an comport in an userform and wrote code inside the userform which read the data form comport.
My problem is that I can’t find out how to add the comport to the userform.
Do anybody know how?
I registered the MSCOMM32.ocx running this bat file:

regsvr32 %windir%\syswow64/MSCOMM32.ocx
Posted
Updated 8-Jan-16 1:27am
v2
Comments

1 solution

 
Share this answer
 
Comments
Koppelgaard 8-Jan-16 13:47pm    
As far as I can see the example involves Visual Basic.
I only got Excel and VBA and need – I think – to place an comport ICON in a USERFORM in order to get data from the comport.
Correct me if I’m wrong.
Maciej Los 8-Jan-16 14:01pm    
Yes, that has been written in 2. point
"Place Microsoft Comm Control on Form1. If Microsoft Comm Control cannot be found in the control bar, go to Tools menu, choose Custom Controls, and then check the Microsoft Comm Control on the List Box."
Koppelgaard 8-Jan-16 14:17pm    
But they are talking about VISUAL BASIC and I only got VBA and under VBA’s tool menu I can’t find any Custom Controls
Maciej Los 8-Jan-16 14:27pm    
Open VBA code editor window. Add new UserForm. Go to Toolbox and right-click on it. Choose "Additional controls". Find and select MSCOMM32.ocx. Now, you're able to place this control on the form.
Cheers,
Maciej
Koppelgaard 8-Jan-16 16:55pm    
Now I managed to find the control. I selected ‘Microsoft communication control’ and then the control was visible. BUT when I try to drag it into the Userform I get following message:
‘The control could not be created because it is not properly licensed’

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900