listbox

  1. D

    Userform Listbox Not Returning Selected Value (.Text)

    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...
  2. K

    How to display filtered data on a listbox

    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...
  3. C

    UserForm with combobox and listbox depending on this

    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...
  4. J

    Using Listbox to alter data in the worksheet

    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...
  5. J

    VBA code to allow changes to existing worksheet data

    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...
  6. J

    VBA Combobox options to be filtered by three other comboboxes

    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...
  7. S

    Automation Error on Keypress in Userform Listbox

    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...
  8. D

    Make font Change to all also future Listbox

    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 =...
  9. S

    Userform Activate listbox in VBA

    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...
  10. D

    Make some CheckBoxes in one Form behavie according to a ListBox of another Form

    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...
  11. A

    Reading all items from a Listbox into an array

    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...
  12. J

    Refresh spreadsheet when listbox updated

    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...
  13. G

    Populate Access ListBox with Distinct/Unique Values

    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...
  14. D

    VBA ListBox variable/object type

    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...
  15. B

    Userform ListBox - Display a Tick if Condition is Met

    Is it possible in a ListBox that has its row source from a spreadsheet that it can display a symbol like a Tick if the value in the row source was the value "YES" for example ? I have a column that will only have the value YES or No and would like to display a Tick or Cross rather than the...
  16. G

    Creating a group for items in a listbox

    Is there a way to create groups of line items from the listbox? I have a userform that allows me to show and hide certain columns. There are 2 listboxes in the userform; one to 'Show' the list item and the other to 'Hide' the list item. By double clicking the items in the listboxes, a user can...
  17. G

    Remove blank items from a listbox

    I have a listbox that loads the list items from a range of cells. Some of the cell values in the range are blank, therefore when the code is executed, the listbox loads the blank cells in as well. I would like to see if there is a way to have the code remove the blank values from the list. I've...
  18. sharky12345

    Listbox dates not formatted correctly

    I have a strange behaviour occurring whilst trying to load a Listbox on a Userform. I have the following code which populates the Listbox with data dependant on the value of column E: Private Sub UserForm_Initialize()Dim Rng As Range, Dn As Range, c As Long, Ray() Set Rng = Range(Range("A2")...
  19. G

    Rearrange column headers using listbox

    I'm looking for a way to move line items in a listbox to rearrange the order of my table headers. So maybe a click and drag approach where I click and hold one line item in my listbox and drag it to a different position in the listbox so that it changes the table header location. Or maybe...
  20. A

    userform listbox - using find to populate

    hi all, i'm using the following code to find a particular name in my workbook, and then return particular cell value from the sheets on which it is found. Public Sub search() Dim ws As Worksheet Dim rngFound As Range Dim strFirst As String Dim strSearch As String Dim...

Some videos you may like

This Week's Hot Topics

Top