+ Reply to Thread
Results 1 to 3 of 3

delete combobox

  1. #1
    Roman Töngi
    Guest

    delete combobox

    How can I delete a combobox placed in a worksheet by VBA, after
    I no longer need it? Or can it be hidden? But it has no visible-property.

    Best wishes Roman
    Excel 2002



  2. #2
    Tom Ogilvy
    Guest

    Re: delete combobox

    worksheets("Sheet1").OleObjects("Combobox1").Delete

    or

    worksheets("Sheet1").OleObjects("Combobox1").Visible = False

    --
    Regards,
    Tom Ogilvy

    "Roman Töngi" <[email protected]> wrote in message
    news:[email protected]...
    > How can I delete a combobox placed in a worksheet by VBA, after
    > I no longer need it? Or can it be hidden? But it has no visible-property.
    >
    > Best wishes Roman
    > Excel 2002
    >
    >




  3. #3
    Roman T&ouml;ngi
    Guest

    Re: delete combobox

    thanks



+ 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