Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove UserForm
I have a program that has multiple userforms. I want to build a progra
that removes one and replaces it with another. I know how to import i the new userform, but can't seem to remove the old one. Does anybod know the proper coding for removing a userform -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove UserForm
Here is an example
Dim VBComp As Object MsgBox "hello" Set VBComp = ThisWorkbook.VBProject.vbcomponents("Module2") ThisWorkbook.VBProject.vbcomponents.Remove VBComp -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "lostthought " wrote in message ... I have a program that has multiple userforms. I want to build a program that removes one and replaces it with another. I know how to import in the new userform, but can't seem to remove the old one. Does anybody know the proper coding for removing a userform? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove UserForm
Thanks for the Help......finally a site with people who are actuall
helpful -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove UserForm
Thanks for the Help......finally a site with people who are actuall
helpful -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove UserForm
Glad to help
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "lostthought " wrote in message ... Thanks for the Help......finally a site with people who are actually helpful. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i remove an excel link that break link won't remove | Excel Worksheet Functions | |||
remove convert/extract the number from'12345.56; ie remove ' sign | Excel Worksheet Functions | |||
How do I remove hyperlink if 'remove' option is disabled | New Users to Excel | |||
Userform inside another userform | Excel Programming | |||
Is there a way to remove numbers w/o remove formulas | Excel Programming |