View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
 
Posts: 595
Default Excel Forms Properties

On Mon, 9 Feb 2009 11:39:01 -0800, vello
wrote:

Is there a way to print out all properties for a UserForm?


Run this code

Sub GetUFProps()

Dim uf As UserForm1

Set uf = New UserForm1

Stop

End Sub

Change UserForm1 to whatever your userform is called. When you hit the Stop
line, choose Locals from the View menu. Expand uf. Do a screen capture and
print.
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com