Excel 2010 VBA Tutorial 55 - ActiveX Controls - Text Box

How to use Active X Controls to add user input text boxes to your spreadsheets.

[rafaelortiz]

Thank u so much! I spent too many time looking for this line of code!

[Rodoxk]

The only problem with Text Box ActiveX is that it might work WHILE you're editing your file. But once you save it and then open the file again, Office will block the text box from registering any data, no matter what security settings you have. This is where I'm stuck right now. Any help would be very much appreciated.