+ Reply to Thread
Results 1 to 5 of 5

Showing Space when Sorting and unique data of Combobox

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Post Showing Space when Sorting and unique data of Combobox

    hi, everyone
    i getting space when combobox populating with sorting and unique data

    please check why its showing a space in combobox list

    here is my code
    Please Login or Register  to view this content.
    Thanx
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Showing Space when Sorting and unique data of Combobox

    Is all the data in the range same type?
    Otherwise you will need more fix...

    Anyway
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Showing Space when Sorting and unique data of Combobox

    Perfect Jindon Sir,


    thanx alot

    Sir i have a question

    if i have not same type data in range?

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Showing Space when Sorting and unique data of Combobox

    ArrayList can handle only one data type at a time.

    So, if you have String type data and Numerical data as well, you can not sort.
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Showing Space when Sorting and unique data of Combobox

    OK
    thanx for reply

+ 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. Replies: 1
    Last Post: 10-12-2015, 04:53 PM
  2. Find data based off unique identifiers and return only columns showing data
    By yomamma34 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-23-2014, 05:03 PM
  3. [SOLVED] userform opening on sheet2 but not showing combobox data values
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2014, 08:29 AM
  4. Replies: 0
    Last Post: 08-23-2012, 12:36 PM
  5. Formulas showing a SPACE when pasted
    By brokenbiscuits in forum Excel General
    Replies: 7
    Last Post: 06-15-2011, 10:08 AM
  6. Sorting Combobox filled with unique value from Column
    By jberr in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-29-2010, 10:13 AM
  7. Combobox - Sorting Data
    By teresa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2005, 01:06 PM

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