I'd like my end users to be able to type a text note and store it in an excel sheet. The note would be edited by the next shift, and then saved to the spreadsheet. There's no requirement to save it other than the next person would be able to see the concerns of the prior person. Very simple stuff. I am using a textbox in a vba form, and I'd like to disable the enter key because it takes them out of the textbox to the next control in the tab sequence. I'm trying to force the end user use the mouse to save and print the note and exit the section.
Is there a better way to handle user notes in excel other than using a textbox and storing that to a field?
Is there a better way to handle user notes in excel other than using a textbox and storing that to a field?
