listbox

Hi currently I have a userform with a listbox that displays the data I've selected in textboxes but whatever code I try to insert the new data to either the listbox or cells of the highlighted line in the list box I get error "70" listbox does not have permission.

Using the Developer ribbon, Excel allows you to add listboxes and even to make them multi-select, but doesn't give you a way of listing the multiple selections in the worksheet. If you set your listbox up like this your cell link will just show 0 - basically the listbox breaks. (I know the...

Hi everybody. I have a problem with a population of a listbox using the method Application.index. I need load a listbox with a series of data in a sheet. I only need just some data (some rows) of the sheet. This data is filtered by a intelligent search that indicate which row should be load in...

I am new to VBA. Some help would be highly appreciated. :) I have two form control multiselect listboxes. I want to filter the source data worksheet based on selection in listbox 12 and listbox 11. The code is working fine when i multi select items from both listboxes and enter search. But I'm...

Hi. Not sure this is possible, but here goes: I have a multi-column multi-select listbox. It's populated from a dynamic range on a sheet (width of the range does not change but number of rows does). The listbox is on a userform with a submit button that write values from the form to another...

Hi, Done some searching and sheet is not protected as others have had the issue with - its just being created as a new workbook. So this is part of a word macro I am updating that I wrote before, but inside the macro I call the Excel creation function. The goal is I want to create an excel...

Hi all, I have a Userform with two Listboxes and two Labels on it. Both Listboxes are populated in the Initialize procedure and one item is selected in each as a default when the user launches the Userform. I would like the Label1 to show the item selected in the Listbox1 and Label2 to show...

Hello People, I am a begginer learning VBA currently working on a project that involves filtering data, I'm trying to filter a data stored in one specific sheet, this data was previously define as a "Table" so I could easily define my ListBox1 RowSource as the name of the specific "Table". The...

Hi everyone! I created a userform with a combobox and a listbox. The idea is to choose from the combobox, and depending on the choice, to choose from a specific list in the listbox and use that value later on. So what i have done so far, is the following event with Combobox change: Private...

Good Afternoon everyone. I have a worksheet that monitors peoples favorite snacks, see image. I have a combobox1 in a userform which displays a list of all names. When the user selects a name, the preferred choice of snacks appear in the listbox on the userform. Combobox2 has a list of all...

Morning all, I hop I explain this well enough. I have a worksheet that monitors peoples favourite snacks, see image. I have a combobox1 in a userform which displays a list of all names. When the user selects a name, the preferred choice of snacks appear in the listbox on the userform...

Hi All, I have spent a few days searching / trying to make this work, but its just not working. This is the first time I have posted, so I hope this makes sense. I have four comboboxes in a userform. The first one looks through "Column A" and lists all individual items. Combobox2 lists values...

I'm trying to create a Auto-fill Textbox where my users are restricted to options that are already present in a pre-populated list of Assets. I've managed to make it work to the point that when they start typing the letters the Listbox shows up with possible matches and if they double click on...

I have this code that change font size form an cell in excel to all ListBox I have Dim FontSize As Integer FontSize = Worksheets(7).Range("B1") Set xLstBox = ActiveSheet.AddOptInletTable Set xLstBox2 = ActiveSheet.AddOptInletTableCombi Set xLstBox3 = ActiveSheet.AddOptLHF6114 Set xLstBox4 =...

I have a warehouse module that I am completing and have 22 listboxes that consist of 22 pick lines to click on. With this in mind, I have created a Userform Activate that when ever an order has been raised it opens a "check order" userform and the VBA code below selects all 22 listboxes to...

Hey, guys. I put some CheckBoxes in my Form and make all of them invisible. Then I want to make only a few of them visible according to the number of Itens that the 'User' insert on a ListBox from the past Form. I also want to change the captions of these CheckBox to the same name of the itens...

Hi guys. This problem is driving me bananas. I have two list boxes. The first is populated with training subjects that are outstanding for an employee. Using buttons, some subjects are moved across to the second list box. Now, when I click on the OK button, I want all items in the second list...

Hi, I need help writing a vba code which had 7 textboxes and an update button to update the listbox then spreadsheet updated via the listbox. base on the colunm selected from the listbox, it populates through the textboxes. when selected column from listbox is selected, update is made via the...

I'm a CS student in my 4th year, my professor wont grade my assignment because i didn't populate a ListBox correctly (I got a 10/200 but i have an option to turn in 1 revision). The ListBox named "lstCateName" displays a property type (castle, villa, manor) from a table named "tblProperty" on a...

Hi all, I have a UserForm with a ComboBox and a ListBox on it; their respective names are "ComboBox_Field" and "ListBox_Value". Their list values are currently strings, but might be dates or integers as well. Now, I have a function to count the number of selected items in a ListBox...