+ Reply to Thread
Results 1 to 2 of 2

HELP! Listbox items not reselected in correct order

  1. #1
    Registered User
    Join Date
    10-17-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    71

    HELP! Listbox items not reselected in correct order

    I'm having issues with Listbox items getting reselected when my workbook is closed and reopened. I have included some code to ensure that the listboxes are reselected when the workbook is opened, but the corresponding Pivot fields get rearranged when the listbox reselection occurs. You can see this happening when you open up my sample workbook.

    Sample Workbook.xlsm

    Module 3 includes the code for storeing and restoring my listbox selections. The RestoreSelections macro is called on ThisWorkbook

    I just can't seem to figure this out and it seems SO simple! Any assistance is greatly appreciated!

  2. #2
    Registered User
    Join Date
    10-17-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    71

    Re: HELP! Listbox items not reselected in correct order

    I've decided to switch over to using FORM CONTROL listboxes instead of ActiveX to avoid these issues with deslections and resizing. What a pain!

+ 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] Auto select items in a Listbox with items from another Listbox
    By perducci in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-22-2013, 04:45 PM
  2. Editing listbox items in Dblclick event freezes Excel unless mouse moves over listbox
    By muneebmansoor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-28-2013, 02:21 PM
  3. Transfer random listbox items to new listbox and then loop through selected items
    By narrowgate88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 05:58 PM
  4. Same order of listbox items in two listboxes
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2010, 09:55 AM
  5. ListBox items paste into worksheet in reverse order
    By Casey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2006, 01:19 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