rowsource property

Hello, I have tried everything to find a solution for that. My code is working perfectly on Windows. Is there any equivalent function for the RowSource to use in Excel for Mac? I do not want to use listbox.add, because I want for multiple columns. This is my code that works perfectly on Windows...

So, somehow I was able to get the list to show up like I wanted. then I wanted to do better, deleted the code aaaaaaaaaand it won't work. Now I can't even get the RowSource to work with the Name Manger dynamic range I set up. At one point I could get a click event to run but not return anything...

Hi All, I am creating a couple of listboxes for my users. The first listbox is a list of clients. The second list is a list of projects. I have a separate macro running to copy and paste some data depending on the users' selections. I need to give the users the ability to run either a...

I'm stumped. I have read threads and tried solutions for changing the RowSource property of a ComboBox using VBA. I can type the Lookup!RangeName into the Properties box and it all works fine. But when I try something along the lines of UserForm.ComboBox.RowSource="Lookup!RangeName" nothing...

I have a spreadsheet with the name "S1" in a workbook with the name "W1" and have an addin with the name "A1". In A1 there is a listbox in a user form. I want to bind a range in S1 to the listbox in A1. This is the only way I can display more than 10 columns of S1 in the list box. When I run...

Hello, I am currently creating a form that will allow the user to select a portfolio, and then select an item in that portfolio using drop down menus. I have the Sheet being accessed set up in the following manor: <tbody> A B C D E F G 1 Portfolio List Portfolio 1 Portfolio 2 Portfolio 3...

Hi everyone, I have an issue setting the rowsource property in a combobox in a form. I set the property to a defined range depending on a value on a cell, The first time the process runs works perfectly, but if I go back to the previous form and try to reload it it gives the error. This...

I have an user form with a combobox. I want to set the dropdown list. If I set it through the properties of the combobox, it is a fixed length dropdown list. i.e. combobox2.rowsource="A1:A18" has eighteen cells in coumn "A". I want to make the figure 18 as a variable depending upon the number of...