Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you delete controls on a form
Greetings,
We have a slight problem we have a series of controls that are still active yet we can not find them in a form. The problem would be is that they have been accidentally moved somewhere in the form yet we can not find them. I can access them, change names etc but I need to find a way to delete them. Any suggestions would be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you delete controls on a form
Try moving it into view like this... in the VB editor, click on the drop
down at the top of the Properties window (press F4 if you don't see it) and select the control you want to "find" from the list; then set the Top and Left properties for it to zero... it should now be in view on the form... do what you want with it. -- Rick (MVP - Excel) "David Adamson" wrote in message ... Greetings, We have a slight problem we have a series of controls that are still active yet we can not find them in a form. The problem would be is that they have been accidentally moved somewhere in the form yet we can not find them. I can access them, change names etc but I need to find a way to delete them. Any suggestions would be appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you delete controls on a form
Rick Rothstein wrote:
Try moving it into view like this... in the VB editor, click on the drop down at the top of the Properties window (press F4 if you don't see it) and select the control you want to "find" from the list; then set the Top and Left properties for it to zero... it should now be in view on the form... do what you want with it. Cheers Rick. I'll give it a go Thanks again David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Form controls | Excel Programming | |||
about more controls of a form | Excel Programming | |||
How to query the controls in form using vb | Excel Programming | |||
user form controls | Excel Programming |