View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter[_59_] Peter[_59_] is offline
external usenet poster
 
Posts: 7
Default VBA code to list names of controls on user form?

Hi guys,

Can anyone suggest how I could write some code that would return all
the control names on a user form?

I've designed the form and re-named all the controls to something
meaningful. I know that when I right click the form to get a tab order
it displays all the field names so what I really want is a similar
thing that I can output for reference when writing the code.

Thanks in advance

Pete