+ Reply to Thread
Results 1 to 2 of 2

Preselecting listbox options from , and chr(10) divided reference cell.

  1. #1
    Registered User
    Join Date
    03-09-2020
    Location
    London
    MS-Off Ver
    Office 365 Excel
    Posts
    1

    Question Preselecting listbox options from , and chr(10) divided reference cell.

    Hi all,

    I have a user-form which inputs data into a "database" worksheet. I have an "edit" command button which then repopulates the user-form in "EDIT" mode.

    Upon clicking the "Edit" button on the "Home" work sheet, I would like to be able to pre-select the list box options based on the entries in the reference cell in the Database!ColumnI "Location of Employment" which is comma and chr(10) separated on to a new line. I know that the sub needs to loop but i am struggling to understand in general where i am going wrong.

    Please see attached file.

    Any help would be much appreciated.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,120

    Re: Preselecting listbox options from , and chr(10) divided reference cell.

    Administrative note

    Hi and weclome
    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks

+ 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. Tick Listbox options based on Cell Values
    By Ravenous in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2018, 03:02 AM
  2. [SOLVED] formula having a cell reference which has to be divided by the value of that cell ref
    By green369 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-24-2014, 11:09 PM
  3. [SOLVED] ListBox - Copy all selected options into a single cell seperated by commas
    By AusTempest in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 03-31-2014, 08:04 AM
  4. Preselecting userform listbox values
    By rubthebuddha in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 12:22 PM
  5. Replies: 0
    Last Post: 02-21-2013, 02:06 PM
  6. reference listbox value to a cell?
    By tsiguy96 in forum Excel General
    Replies: 2
    Last Post: 02-06-2013, 10:32 PM
  7. Conditional Cell Reference / Multiple options
    By Spawnofsanta in forum Excel General
    Replies: 4
    Last Post: 06-15-2012, 12:52 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1