Results 1 to 4 of 4

Thread: deleting combo in excel

  1. #1
    Join Date
    Oct 2008
    Posts
    83

    deleting combo in excel

    Hello everyone,

    I have an Excel file in which certain cells are set up to display a scrolling list of choices, and they does not allow the entry of any text other than the choices offered. I would like to delete these lists. can you tell me How?
    Thank you in advance

  2. #2
    Join Date
    May 2008
    Posts
    4,345

    Re: deleting combo in excel

    I suppose it is an ActiveX control. To select and delete, you must be in Design. Displays the Toolbar "Control Toolbox", activates Design (1st button on the toolbar) and delete your list.

  3. #3
    Join Date
    May 2008
    Posts
    4,570

    Re: deleting combo in excel

    You select an element by Right-click>> Context Menu and choose to remove the column(s), but it will cause loss of data list , also By the toolbox controls: you can Switch to design mode (click on the button with a pencil and a bracket) Select the check box list and delete with the Delete key

  4. #4
    Join Date
    Apr 2008
    Posts
    4,642

    Re: deleting combo in excel

    For the Forms toolbox: Skip to the control with the mouse once on top, making a click Right then delete with the Delete key

    or use

    Visual Basic (Declaration)
    Public Function Delete As Object

    Deletes a dynamically created ComboBox from the worksheet and removes it from the ControlCollection.This method should only be used with a ComboBox that is created programmatically at run time. An exception is thrown if you call this method on a ComboBox that is added to the worksheet at design time.

Similar Threads

  1. Excel 2007 - insert button, checkbox, combo box etc.
    By Hardik in forum MS Office Support
    Replies: 3
    Last Post: 06-10-2011, 07:38 PM
  2. Deleting password protected word and excel files
    By Amolya Tikam in forum Windows Software
    Replies: 5
    Last Post: 10-03-2010, 12:51 PM
  3. How to Add Combo Box to a Worksheet of Excel?
    By Pratim in forum Windows Software
    Replies: 5
    Last Post: 06-01-2010, 06:07 PM
  4. Macro for deleting every alternate row in Excel 2007
    By Akiraa in forum Windows Software
    Replies: 3
    Last Post: 22-10-2009, 10:19 PM
  5. How to prevent users from deleting Word/Excel files in a Share?
    By SidharthGore in forum Windows Security
    Replies: 3
    Last Post: 16-05-2008, 11:19 PM

Tags for this Thread

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
  •  
Page generated in 1,711,614,663.57109 seconds with 16 queries