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!
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!
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
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.
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!
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 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
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
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
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
Still getting an error, thoguh a different one at this time
Do you know why this would be?
(thanks so much, btw)
ListBoxUserForm3.PNG
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.
The Permission Denied might be related to the rowsource propery being other than "". Try changing that in the Property Window.
How about a sample file ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks