1. V

    How to not allow an entry of '0' in a ComboBox

    I have a combobox in a user form for quantities to be entered. The quantities can only be numbers through the use of the following keypress macro: Private Sub CaseQty_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) If (KeyAscii > 47 And KeyAscii < 58) Then KeyAscii = KeyAscii...
  2. A

    Check if combobox has assigned value

    Hello, I am using the value selected in a combobox as a sort of filter, as in If Range("A1")=ActiveSheet.OLEObjects("ComboBox1").Object.Value Then Range("B1") = Range("A1").value/ ActiveSheet.OLEObjects("ComboBox1").Object.Value However if ActiveSheet.OLEObjects("ComboBox1").Object.Value is...
  3. N

    UserForm showing list of all sheets, ability to delete sheets

    Hello, I am hoping to find a way to create a userform, that lists all sheets within a workbook, and somehow gives the user the opportunity to select which sheets they would like to delete from that list. Is this possible?
  4. L

    combobox return numerical value for further calculations with other userform functions

    Hi, I am fairly new to VBA and I need to quickly construct a simple userform for work. To put it simply, I have a list of items each with corresponding price (2 groups, one group is a subset of the other group of major items), I would like to construct a userform where the user can use a...
  5. P

    VBA Worksheet Combobox Font color setting

    I have the following code which programmatically adds a combobox to a worksheet. Set Cell = WSD.Range("J2") WSD.OLEObjects.Add(ClassType:="Forms.ComboBox.1", link:=False, _ DisplayAsIcon:=False, Left:=Cell.Left - 5, Top:=Cell.Top + 3, Width:=Cell.Width + 125...
  6. J

    Listbox to populated based on two (unlinked) combo boxes

    Hi I have a table of data I wish to "filter" using two comboboxes and display the matching results in a listbox. Colour Item Stock Red Apple 5 Yellow Peach 13 Green Pear 1 Red Cherry 0 Red Raspberry -10 Yellow Plum 2 Yellow Apricot 0 Red Strawberry 3 Combobox1 should list...
  7. M

    Excel VBA: How to create custom color filter (combo box control with all option) in Excel

    I have a need: create a combo box (or maybe something else) to filter my file by COLOR and INCLUDING ALL OPTION. sample data listed below. Goal is when color red, orange, or yellow selected at B7 Combo Box, rows under column c will be filtered accordingly with understanding that any uncolored...
  8. Jaafar Tribak

    MouseWheelScrolling ListBoxes & ComboBoxes (In worksheets and UserForms)

    Hi all, This is a continuation of this MrExcel thread which grew to the point where it became confusing and difficult to follow with so many small updates and improvements. So I am starting here a fresh clean thread with (hopefully) a final update which has been revised and tested on 32bit &...
  9. V

    Display listbox data based on Combobox value

    Hi I'm trying to display data based on a combobox and data in Column D. current code below Sub UserForm_Initialize() Dim lIndex As Long Dim rngMultiColumn As Range Set rngMultiColumn = ThisWorkbook.Worksheets("Sheet3").Range("A4:N100") With Me.AllocateBox1 .ColumnCount = 14...
  10. J

    Populating Listbox based on ComboBox selection - VBA

    Hi, Im looking to populate a list box (5 coloums) based on the selection a user makes in a combobox. However, the options in the combobox are not unique, so there will be multiple sets of data to display. Name Age Hair Colour Jack 34 Brown Ben 23 Blonde Steve 45 Grey Jack 65 Black...
  11. O

    ComboBox List Bug

    I built a userfrom to track what we call 'Take 30's' with our employees. I have several combobox's but one of them has issues about half the time. The employee combobox rowsource is referencing a named range which changes based on the value selected in the manager box. Essentially, when the...
  12. C

    Vlookup combo box value to populate textbox

    Hi everyone! Newbie here, I have a small Userform with a couple of textboxes and one combobox. The combo box is populated from a sheet named "Nombres" ComboBox1.List = Sheets("Nombres").Range("A1:A130").Value So what I need is that, after the User select or change something in the...
  13. 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...
  14. 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...
  15. D

    Is it possible to populate a combo box with a range or values that exists 1 row and not a column?

    I have a dynamic range that all the info in is 1 row and I want to use it to populate a combo box but I can only get the value in the first cell to show in the combo box. Range named adbk is on a tab named Admin and the data starts in b1 and stretches out on row 1 below is the line of code that...
  16. P

    Combox is slow and floats in other sheets

    Hi, I used a combox that fills as you type in a project with a long list. I used this option instead of the regular dropbox, because at time we have more than 1000 options to choose from, and it easier for the user to start typing and selecting. The only issue I am having with the combox, is...
  17. N

    Removing an item in ComboBox list if already selected in the other Combobox

    I have 2 ComboBoxes. Both have same items inside. What I want to do is when say if "Report1" is selected in ComboBox1, ComboBox2 should not show "Report1" in the list and vice versa. Thanks. So far I only have this: Private Sub Workbook_Open() Worksheets("Settings").ComboBox1.Value =...
  18. N

    Show different value in ComboBox from selected list

    I have a ComboBox (Quart1) in a userform with the ff list of items added at Userform Initialize: Private Sub UserForm_Initialize() With Quart1 .AddItem "Q1 (Jan to Mar)" .AddItem "Q2 (Apr to Jun)" .AddItem "Q3 (Jul to Sep)" .AddItem "Q4 (Oct to...
  19. D

    Initialize a UserForm with custom name

    Hi, I need to create a UserForm containing a ComboBox initialized with two pre-defined values. The UserForm code looks like this: Private Sub UserForm_Initialize() ComboBox1.AddItem "Value_A" ComboBox1.AddItem "Value_B" End Sub If I run the code, the results are as expected ONLY if the...
  20. S

    ComboBox selected record’s all columns visible?

    Hi all, After DropButton Clicking, it shows all CoboBox’s records with columns visible, but after selecting a record from list, CoboBox shows first column’s value only, rest columns are hidden. Is there a way to show selected record’s all columns? Thank you in advance

Watch MrExcel Video

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