+ Reply to Thread
Results 1 to 15 of 15

UserFrom ListBox blank on Mac

  1. #1
    Forum Contributor
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    MS Office: Excel 365
    Posts
    144

    UserFrom ListBox blank on Mac

    Hi --

    On a PC I created a UserForm which has a ListBox.
    However, when trying to run on a Mac, the ListBox is blank.
    I've tried finding a solution, but have had no luck.
    Does anyone know how to fix so that the list is populated on a Mac?
    Thank you!

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,928

    Re: UserFrom ListBox blank on Mac

    How about telling us more, like WHAT are you populating it with.
    What's the source for the listbox?
    Have you use ActiveX elements? That may not work on a Mac
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,207

    Re: UserFrom ListBox blank on Mac

    If you are using Rowsource that might be a reason. Rowsource is not supported on Mac.

    What is the code you are currently using to populate the ListBox on a PC?
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  4. #4
    Forum Contributor
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    MS Office: Excel 365
    Posts
    144

    Re: UserFrom ListBox blank on Mac

    Hi --

    No code is being used to pupolayte the list box and no, ActiveX is not being used.
    The list box is populated by a simple cell range (see below):

    ListBoxUserForm.PNG

    hope this helps
    Thanks!

  5. #5
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,207

    Re: UserFrom ListBox blank on Mac

    That is why it is blank on the Mac.
    What you should do is put this in the userform's Initialize event

    Please Login or Register  to view this content.

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,928

    Re: UserFrom ListBox blank on Mac

    I think you should read Ron de Bruin's site; here's the link: http://www.rondebruin.nl/mac/mac027.htm
    I just started to help my daughter with Excel on a Mac (vs 2011) and need to learn the differences.
    It's an eye-opener, I can advice his site : http://www.rondebruin.nl/mac/section1.htm

  7. #7
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,301

    Re: UserFrom ListBox blank on Mac

    I don't think the Transpose is necessary. (It's never really necessary for a listbox/combobox as you can just use the Column property instead of List).
    Rory
    I drink, and I know things

  8. #8
    Forum Contributor
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    MS Office: Excel 365
    Posts
    144

    Re: UserFrom ListBox blank on Mac

    Quote Originally Posted by mikerickson View Post
    That is why it is blank on the Mac.
    What you should do is put this in the userform's Initialize event

    Please Login or Register  to view this content.
    I having an issue getting this to work. I placed it here, and still get an error (now on both PC & Mac version) -- it debugs to this line. Am I doing something wrong?
    Maybe a more detailed explanation on where to put would help.
    Thank you!

  9. #9
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,207

    Re: UserFrom ListBox blank on Mac

    What is the error that line causes?

  10. #10
    Forum Contributor
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    MS Office: Excel 365
    Posts
    144

    Re: UserFrom ListBox blank on Mac

    Quote Originally Posted by mikerickson View Post
    What is the error that line causes?
    Run-time error '424':
    Object required

    this is where i placed it (forgot to attach in last note):
    ListBoxUserForm2.PNG

  11. #11
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,928

    Re: UserFrom ListBox blank on Mac

    It doesn't work like that:

    You have to load the form the fill it and then show it

    Please Login or Register  to view this content.
    Last edited by Keebellah; 11-30-2018 at 05:29 PM. Reason: missing text and code tags

  12. #12
    Forum Contributor
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    MS Office: Excel 365
    Posts
    144

    Re: UserFrom ListBox blank on Mac

    Quote Originally Posted by Keebellah View Post
    It doesn't work like that:

    You have to load the form the fill it and then show it

    Please Login or Register  to view this content.
    Still getting an error, thoguh a different one at this time
    Do you know why this would be?
    (thanks so much, btw)
    ListBoxUserForm3.PNG

  13. #13
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,928

    Re: UserFrom ListBox blank on Mac

    Does this happen on both systems?
    Looks like an access denied issue
    If you Google this error you get some hits and explanations, one of them is:
    "Permission Denied" is not for a protected worksheet but for wrong access to a property or variable.
    Last edited by Keebellah; 11-30-2018 at 06:52 PM.

  14. #14
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,207

    Re: UserFrom ListBox blank on Mac

    The Permission Denied might be related to the rowsource propery being other than "". Try changing that in the Property Window.

  15. #15
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,928

    Re: UserFrom ListBox blank on Mac

    How about a sample file ?

+ 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] ListBox Array creates blank ListBox item
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-16-2019, 12:33 PM
  2. Leaving UserFrom Fields Blank on Purpose: Mismatch Error
    By Ocean of Ice in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2016, 10:18 PM
  3. VBA code for a search of data and return result to a listbox on userfrom
    By stevebreslin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2013, 04:14 AM
  4. Bold items in Userfrom ListBox
    By klonbeck in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-07-2013, 03:14 PM
  5. [SOLVED] Insert blank rows by a userfrom
    By Danielle22 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-17-2013, 08:21 AM
  6. Blank value in Listbox
    By vijay2482 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2009, 10:23 AM
  7. Blank spaces in a listbox
    By Soundman in forum Excel General
    Replies: 3
    Last Post: 08-17-2005, 09:13 AM

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