I'm looking for a creative idea. I'm seeking a Macro that can be run from any point in a WB, and I'm thinking object or potentially a "Form" that when run, can be brought up (exposed) that will behave like a Text object (to collect Notes) and then easily be closed until used again later. In other words it would be like being in the middle of a WS entering data as normal in Excel. Is there an easy way to fire a macro (via a button) and have a form appear that records text as you add commentary? As Text commentary the form/box/object would word wrap as well as respond to normal carriage returns and text changes (bold, italic, color, etc.). Finally, the text needs to be able to be cleared.
Looking for a creative way to do this.
Thank you in advance,