Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Removing a userform from Excel VBA 1

Status
Not open for further replies.
peterpcu

peterpcu

MIS
Sep 15, 2005
31
GB
Hi,

Just a quick question - how do you remove a userform from an application by using VBA code?

Regards

PCU
 
Sort by date Sort by votes
An excel VBA example:
With ActiveWorkbook.VBProject
.VBComponents.Remove .VBComponents("UserForm1")
End With

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
831
huiettcm
huiettcm
remeng
  • Locked
  • Question
Run PowerShell Commands from Excel VBA
Replies
14
Views
4K
dhookom
dhookom
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
1K
remeng
remeng
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
936
hermanlaksko
hermanlaksko
thanhthanh12
  • Locked
  • Question
Help vba
Replies
3
Views
600
combo
combo

Part and Inventory Search

Sponsor

Back
Top