Delete textbox after exit

[kylekelsch]

Is there a way in VBA to delete a worksheet textbox after you exit it.
I've tried the KeyPress event but it gives me a error and excel has to
shut down. I think the error has to do with the fact that I am
deleting the textbox that triggered the event but I'm not sure. Any
help would be greatly appreciated.

 

[Bob Phillips]

Use Application.OnTime to trigger procedure to run in say 1 sec that
deletes that textbox.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[kylekelsch]

Thanks for your reply Bob.

I'm pretty new to VBA. Can you give me a little example.

 

[Bob Phillips]

Kyle,

Read this first, http://www.cpearson.com/excel/ontime.htm, and then post
back with the bits you are unsure of.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[kylekelsch]

Not unsure about any of it. That worked perfect Bob.
Thanks for you help.

 

[Bob Phillips]

Excellent. Chip obviously did a great job on the page.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)