+ Reply to Thread
Results 1 to 5 of 5

Listbox

  1. #1
    Forum Contributor
    Join Date
    01-21-2021
    Location
    Leeds
    MS-Off Ver
    2016
    Posts
    138

    Listbox

    Hi,

    Thanks for looking at my post

    I have attached demo workbook. When you click Button 1 , userform will open. Depending upon Name selection in the dropdown box , description will pop up in the list box. Issue is , is there any possibilities to bring continuous list of numbers rather than gap between numbers please? but I cant change the format in the sheet 2.

    Any help will be appreciated.

    Thanks,
    Jim
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,947

    Re: Listbox

    Try this.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    01-21-2021
    Location
    Leeds
    MS-Off Ver
    2016
    Posts
    138

    Re: Listbox

    Perfect

    Thanks a lot )

    I think I am doing something wrong. Can you please point me the direction please.

    I have attached the workbook. For first name its works perfectly fine but for rest of the names I am getting an error message. Can you please point me where I am going wrong please?

    Secondly, I have some #VALUE! in the cell and I don't want to see that in the list. Is it something we can do ?

    Really sorry about this and thanks a lot in advance

    Thanks,
    Kind regards,
    Jim
    Attached Files Attached Files
    Last edited by jimpatel1993; 06-03-2021 at 10:18 AM.

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,947

    Re: Listbox

    Possibly

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    01-21-2021
    Location
    Leeds
    MS-Off Ver
    2016
    Posts
    138

    Re: Listbox

    Brilliant

    Thanks a lot again

+ 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] Find as you type in listbox control - solution for multi-column listbox - vba dictionary
    By wazimu13 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-05-2018, 03:42 AM
  2. [SOLVED] Show unique values in listbox and activate related cell if i select value in Listbox
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-22-2018, 06:54 AM
  3. [SOLVED] Loop find all matches of listbox items, display results in another listbox
    By banaanas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-29-2015, 02:56 AM
  4. User Form ListBox - Find Records (ListBox Populating Issue)
    By LONeillSSC in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-20-2015, 12:06 PM
  5. [SOLVED] if anything in listbox select first item, if listbox empty do nothing (listbox in userform
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2015, 12:49 PM
  6. Listbox to Listbox, no duplicates & submitting same UserForm data for each Listbox entry.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2012, 12:18 PM
  7. Replies: 12
    Last Post: 08-28-2012, 07:09 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