+ Reply to Thread
Results 1 to 14 of 14

Strange Icon & drop Box Excel 2010

  1. #1
    Registered User
    Join Date
    09-29-2014
    Location
    Lille, France
    MS-Off Ver
    Excel 2010
    Posts
    34

    Strange Icon & drop Box Excel 2010

    EXCEL problem.png

    Dear All

    Encl pls find att'd file with strange Icon & Drop box.
    I have the problem to delete it from my excel table.
    I have tried the validation & go to "Object" to find the drop box but not success to find any clue how to delete it.

    If you know the answer, kindly advise step by step instruction

    Tks in advance

    Rgds
    Alelman

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,173

    Re: Strange Icon & drop Box Excel 2010

    I do not see anything wrong.
    And you didnt say which field is wrong.

  3. #3
    Registered User
    Join Date
    09-29-2014
    Location
    Lille, France
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Strange Icon & drop Box Excel 2010

    Quote Originally Posted by ranman256 View Post
    I do not see anything wrong.
    And you didnt say which field is wrong.
    It's on A1 which is like the Drop box & filter but it isn't

  4. #4
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,173

    Re: Strange Icon & drop Box Excel 2010

    Is it not got a filter on it? If it does it MAY not show the arrow icon, but should.

  5. #5
    Registered User
    Join Date
    09-29-2014
    Location
    Lille, France
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Strange Icon & drop Box Excel 2010

    Quote Originally Posted by ranman256 View Post
    Is it not got a filter on it? If it does it MAY not show the arrow icon, but should.
    There is not the filter but when I use the filter, it move the another cell. It's not always on A1.
    When I click on it, it's like the drop box but it's empty inside.

  6. #6
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Strange Icon & drop Box Excel 2010

    upload sample file
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  7. #7
    Registered User
    Join Date
    09-29-2014
    Location
    Lille, France
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Strange Icon & drop Box Excel 2010

    Quote Originally Posted by nflsales View Post
    upload sample file
    The problem is not solved yet.
    Pls find the upload file which has those box. (A3 & A14)

    Rgds
    Attached Files Attached Files

  8. #8
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Strange Icon & drop Box Excel 2010

    Run this code:
    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

  9. #9
    Registered User
    Join Date
    09-29-2014
    Location
    Lille, France
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Strange Icon & drop Box Excel 2010

    Quote Originally Posted by romperstomper View Post
    Run this code:
    Please Login or Register  to view this content.
    You are the best.
    I never done the Code before as I am very new for Code
    I just try to Developer tools & find Visual Basic & they pop up my file.
    I choose the file & click on it, they pop up the dialog box & copy your code.
    I am still wonder if I need to save which finally i find the button to Execute the Sub.
    Magic come out, All the drop box is disappear. Really tks a million.
    By the way, if there anything avoid to happen again as i believe it's accident done by my associate colleague which even he does not know what did he do to causing this.

  10. #10
    Registered User
    Join Date
    09-29-2014
    Location
    Lille, France
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Strange Icon & drop Box Excel 2010

    Dear romperstomper

    Sorry to bother you again. The problem is come up again but this time I used your code which does not work.
    Can you advise how does it happen as it seems that it come back time to time which my colleague has no clue how he do it ?
    Sure do you have another solution to solve this again

    Tks in advance

  11. #11
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Strange Icon & drop Box Excel 2010

    Does your colleague copy and paste data into the sheet from the internet?

  12. #12
    Registered User
    Join Date
    09-29-2014
    Location
    Lille, France
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Strange Icon & drop Box Excel 2010

    No, he just do copy & paste from other Excel table for some input.
    Usually we update the data manually & occasionally we copy the data from other Excel table & paste it to our Table.
    However, I don't know if the reason to cause this is that he like to delete the sorting filter for all column & reput it again. As when we update the data, we need to select few filter, in order to be faster the input. He just delete all the filter at once & reput it back.
    Other than that, I don't find anything he do can cause this.

  13. #13
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Strange Icon & drop Box Excel 2010

    I can't see how that would be a problem, to be honest, but you could ask him not to for a while!

  14. #14
    Registered User
    Join Date
    09-29-2014
    Location
    Lille, France
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Strange Icon & drop Box Excel 2010

    Will do & hope it's really the reason for that. Meantime, I just retry your code & save the file under Macro & it's work to delete it.
    However, I put your code which does not require me to save the file in Macro based file.
    I don't want to save it Marco base file as it seems that there is some risk to be attacked by some virus which those database is quite important for our company so I tried to avoid it.
    Do you think that if any way which does not need to save the file in Marco format ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2010 - Icon Set (3 conditions) Based on Cell Value Across
    By robynn in forum Excel General
    Replies: 5
    Last Post: 09-24-2014, 02:03 PM
  2. Application.sendkeys - strange result! - Excel 2010
    By wazimu13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2014, 07:36 AM
  3. Excel 2010 VBA is openning IE in strange format
    By misterno in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2014, 04:50 PM
  4. EMBEDDING / ATTACHING OBJECTS INTO EXCEL 2010 - Missing OLE Object icon???
    By EatBiscuits in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2013, 11:36 AM
  5. Strange icon in the cell
    By aia in forum Excel General
    Replies: 3
    Last Post: 09-02-2008, 10:00 AM

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