Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

VBA Combobox autofill

0

Have code in which the combobox autofill works perfectly on a wndows based system. It wil not autofill on an Apple IOS system. This is the code that works with windows using an array:

Private Sub UserForm_Activate()
    ComboBox1.ColumnCount = 3
    ComboBox1.List() = Volunteer_Array
End Sub

How do I find and set the combobox property for autofill that may work on Apple IOS?

Answer
Discuss

Discussion

Hi NormZ

I don't have a Mac to check this but is the Volunteer_Array as named range on your Mac workbook? What happens if you omit the () after ComboBox1.List or replace the code with this?
Private Sub UserForm_Activate()
    ComboBox1.ColumnCount = 1
    ComboBox1.List = Array("a", "b", "c")
End Sub
John_Ru (rep: 3462) Jun 21, '22 at 4:00 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login