Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ActiveX Controls vs Form Controls Alex Excel Discussion (Misc queries) 1 January 11th 06 08:46 AM
Form controls Sheldon Excel Programming 2 October 22nd 04 01:20 PM
about more controls of a form EXCEL$B!!(BNEWS Excel Programming 0 October 1st 04 08:59 AM
How to query the controls in form using vb Andy Chan Excel Programming 1 September 1st 04 05:12 AM
user form controls chris gee Excel Programming 0 July 15th 03 12:05 AM


All times are GMT +1. The time now is 09:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"