+ Reply to Thread
Results 1 to 3 of 3

Listbox freezes when workbook is opened.

  1. #1
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Waterbury, CT
    MS-Off Ver
    Office 365
    Posts
    1,175

    Listbox freezes when workbook is opened.

    Hi.
    I have a little issue with a list-box. When i open my workbook and i click on the List Box the list box freezes, excel doesn't let me select it until i go to design mode, select the list box then close out of design mode. This sort of "fixes" the issue but i would rather not do so this way.
    Does anyone have any ideas on how this problem can be solved?

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644
    How are you populating the listbox?
    If posting code please use code tags, see here.

  3. #3
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Waterbury, CT
    MS-Off Ver
    Office 365
    Posts
    1,175

    Re: Listbox freezes when workbook is opened.

    From a different sheet on the same workbook.

+ 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. 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
  2. Spreadsheet freezes if opened with hyperlink
    By Ahh Dubya in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2012, 11:28 AM
  3. Reference opened Listbox workbook in for loop
    By rigray in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2012, 07:33 PM
  4. Workbook w/ macros lags or freezes when opened
    By macsrule1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-29-2007, 02:47 AM
  5. pane freezes when file is opened
    By andy b in forum Excel General
    Replies: 3
    Last Post: 07-04-2005, 10:05 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