| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete textbox after exit
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete textbox after exit
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) wrote in message ups.com... 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete textbox after exit
Thanks for your reply Bob.
I'm pretty new to VBA. Can you give me a little example. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete textbox after exit
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) wrote in message ups.com... Thanks for your reply Bob. I'm pretty new to VBA. Can you give me a little example. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete textbox after exit
Not unsure about any of it. That worked perfect Bob.
Thanks for you help. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete textbox after exit
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) wrote in message ps.com... Not unsure about any of it. That worked perfect Bob. Thanks for you help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Private Textbox Exit Sub question... | Excel Worksheet Functions | |||
| Urgent - how to run textbox exit sub? | Excel Programming | |||
| Exit Event with a single textbox control | Excel Programming | |||
| Format textbox on exit | Excel Programming | |||
| How To Get An Event To Run When I Exit A TextBox | Excel Programming | |||
Linear Mode
