addins
 

Can anyone help me how do i attach my userform to a menu using vba.

i.e in case i create a wizard and save as addin, a menu should b
available which will be show the first form of my wizar

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

addins
 

Not exactly sure what you mean, but I think you are asking how do yo
bring up your first wizard page (userform) from the click of a men
option

You will need to make a macro that says

"YourUserForm".show

This will bring it up

example

Sub MyMacroThatShowsMyUserfor ()


myUserfrom.show

End sub

Then you will attach that macro to your menu item that you will need t
create as well


Rees Macleo

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements