listbox value

  1. D

    Active-X Listbox on worksheet

    I have two listboxes on a worksheet and using VBA to load values into the listbox. I also have a combobox that is used to determine what values are to be displayed in the listboxes. I select a value from the dropdown list and depending on the value selected, a list gets populated in the...
  2. A

    retrieving listbox values

    Ok so I am working on a userform that contains a listbox with 3 columns in it (bound column = 0). I'm filling this listbox from a database using .additem. When I attempt the retrieve the first columns selected value I am unable to do so. The MultiSelect property of the listbox is set to: 0 -...
  3. I

    Attempting to filter data

    I'm trying to filter records by date but the Value of frmInput.lstDate.Value is equal to 40999. I've tried to format it my lstDate.value as a date using format(frmInput.lstDate.Value,"mmddyy") but that wasn't quite right either. What am I'm missing? If Not .FilterMode Then...
  4. D

    List Box help

    I have a listbox on a form which I load values using a loop in VBA. The values are in Sheet1!A1:A25. The property list box is set to ColumnHead = True. This works fine showing the Column headers at the beginning of the list. However, I have another listbox on a worksheet in which the...
  5. J

    Listbox Value

    I would like a listbox to list the following text but do not know how to do it, can someone please help. Row 1 in the listbox would be the word - Help File Row 2 in the listbox would be the word - Log File I want it to have many other words but if someone gets me started I can manipulate the...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top