ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Forms Properties (https://www.excelbanter.com/excel-programming/423740-excel-forms-properties.html)

vello

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

Dick Kusleika[_4_]

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


All times are GMT +1. The time now is 03:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com