+ Reply to Thread
Results 1 to 2 of 2

Delete Userform

  1. #1
    Forum Contributor funkymonkUK's Avatar
    Join Date
    01-07-2005
    Location
    London, England
    Posts
    500

    Delete Userform

    how do I delete a userform through code?

  2. #2
    Chip Pearson
    Guest

    Re: 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"
    <funkymonkUK.1vtc2e_1127480755.9483@excelforum-nospam.com> wrote
    in message
    news:funkymonkUK.1vtc2e_1127480755.9483@excelforum-nospam.com...
    >
    > 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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1