VBA Serial COM Port receive data from RFID reader RRS feed

  • Question

  • Hi,

    I have a userform textbox which am typing value manually. But in real scenario the textbox value is an input provided by the value from a RFID reader. The RFID reader is connected to COM1 with Baud rate_19200, data bits 8, Stop bits 1, Parity N, flow control N. The RFID reader is connected to windows PC via RS232 (cable)

    In Vb there is an option to use serialport function directly. Is there a similar simple way to get the serial port number, then read the data from RFID and get the value into Textbox? 

    I am trying to achieve in vba macro. Is it possible in vba?


    Tuesday, November 15, 2016 11:45 AM


  • Hi,

    It is similar in VBA.

    Please see the similar thread: excel 2010 vba send and receive from com1

    You could have a look at the several links Caillen and Andreas shared.



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    • Marked as answer by NewBInCoding Monday, November 21, 2016 7:22 AM
    Wednesday, November 16, 2016 2:48 AM