ExcelBanter - Delete Userform

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Delete Userform (https://www.excelbanter.com/excel-programming/340921-delete-userform.html)

how do I delete a userform through code?

--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=470201

Try something like

With ThisWorkbook.VBProject.VBComponents
.Remove .Item("Userform1")
End With

For more information about working with VBA code, see
www.cpearson.com/excel/vbe.htm .

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"funkymonkUK"
wrote
in message
...

how do I delete a userform through code?

--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread:
http://www.excelforum.com/showthread...hreadid=470201