You might have a hard time using if with VBA. Here is a site to start.

http://thoreau.dnr.state.mn.us/mis/g.../GPSPage23.htm

"Cathy" wrote:

I am trying to find a way of receiving NMEA data from the comm port into an
Excel Sheet.

NMEA is the protocol used by devices such as GPS to connect to laptops. NMEA
0183 is one of the standards.

Any ideas on how I should get started on this would be appreciated

Thanks in advance
C