I am using Excel with Visual Basic in the background to talk Modbus

Brian Hust 1 Reputation point
2022-03-11T15:21:41.667+00:00

I am using an Excel Spreadsheet to read and write data directly to a ModBus device. I have it all working with Visual Basic in the background. However, I had to create a Command Button to send the data to the device. I would like to just use the Enter Button on my keyboard instead of the Command Button to save time and steps.

I ahve been searching for the code to write to do this. Can anyone give me the exact code to write to make this work.

I am not using or want to use Message Boxes as they are just in the way.

I simply want to replace a Command Button with the Enter Key and remove the Command Button.

Thank-you

******@telus.net

Developer technologies Visual Basic for Applications
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.