Thread: Delete Userform
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Delete Userform

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