Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default loop through form objects

Hello,

I created a form and would like to loop through each form object and get
their name and the type of object. Any help with this would be greatly
appreciated.

--
Thanks in advance,

Steven


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default loop through form objects

For N = 0 To Me.Controls.Count - 1
Debug.Print Me.Controls(N).Name
Next

--
Message posted from http://www.ExcelForum.com

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
Deleting HTML form objects? GeorgeM Excel Discussion (Misc queries) 3 December 29th 06 11:24 PM
Stop Excel form objects being printed Jong Excel Discussion (Misc queries) 1 December 7th 05 02:36 PM
Moving objects on a form Steven K Excel Programming 1 August 23rd 04 06:13 PM
editing control/form objects on a worksheet Ricky M. Medley Excel Programming 2 December 10th 03 02:50 PM
Can't insert form objects Mat Excel Programming 2 November 9th 03 01:50 AM


All times are GMT +1. The time now is 04:37 AM.

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

About Us

"It's about Microsoft Excel"