Using QuickText in Text Box inside Excel

Question

I'm trying to insert a Quick Text date (the date always shows the current date or the date the document is printed) inside a Text Box in Excel 2010 and am not finding any Quick Text options inside Excel.

I know I could do this in this particular file by changing this particular text box into text inside some cells. It would work this way then using the various date functions in Excel formulas.

However, I'd like to know if it is possible, and if so, how to use quick text inside a text box in Excel.

Answer 1

Use the macro recorder to insert a text box and type anything whatsover into it. Stop the recorder. Open the VB editor (alt-F11 will do it). Cut the recorded macro from the module and paste it in the sheet object module. In that module there will be a few dropdown boxes. Use the one that reads "General" and change it to "Worksheet". Then use the dropdown to the right of it to pick "sheet_activate" or "before_print", or do both. I'm on linux now so I can't do a quick look, but you may have to use "Workbook" module to get the "before_print" event. When you pick these things, a stub of code is inserted. You'll use the macro you recorded as a template for code you put in the stubs. Get familiar with the functions Now(), Date(), and Format(). You'll also have to figure out it you can replace the text in an existing textbox or destroy and recreate it everytime. Sorry this is more a hint than a how-to. It should be easy to do. If google and a little persistence doesn't yield the desired result, post a comment here. I can show you the whole code to do it. Traveling Sep 7 so won't respond that day. Good Luck.