I have made some changes/additions to your code. I hope this is what you are looking to do.
1. Created a text box for COB_Date
2. Put code behind cancel button
3. Put code behind clear button
4. Added code to OK button to clear text boxes after update.
5. Set tab order of events to follow the order of the text boxes and command buttons.
6. Added a command button to load the data from the text boxes to the commentary.
7. Set the properties in the commentary box for multi-line to TRUE
I did notice that the commentary box does not go anywhere. It is not saved to any particular location on your spreadsheet. Is this an oversight?




Reply With Quote

Bookmarks