combobox

Hi everyone, I found this module which allows scrolling with the mouse wheel ComboBox and ListBox. It works well as long as the workbook is opened on the main display but if you working with multiple displays and have your spreadsheet application opened on a different display the mouse wheel...

This is too specific for me to find any relevant info on the internet, at least from my searches, and I'm wondering if anyone can help out. I've created a userform that is filled in by user. I would then like to use the values entered in the textboxes in this userform to populate a new lastrow...

Excel doesn't provide a built-in way to search data validation list. So it could be hard to scroll through the list when the list is long. This searchable data validation+combobox is a way to deal with that problem. It has these behavior: 1. The combobox can appear and hide by certain action e.g...

Hello, So I have an interesting problem, I am making a maintenance list for many machines and tools. I would like the first sheet of my workbook to be the only visible sheet in the workbook and everything else to be hidden. I have already made it so I have another sheet that is a so called...

Hi there. I am for hours searching an solution but nothing till now. Or it is impossible or I just wasn't able to reproduce what I've sen on my workbook. So, here it goes: I've set a named range com a list of banks (on sheet3!) and I want to maintain that way because there is the possibility...

I have two textboxes (TextBox1, TextBox2) that need to be disabled based on combobox1. I need the textbox to be "gray out" to show they are disabled ?How can i do it ? Private Sub ComboBox1_Change() If ComboBox1.Value = "Section" Then TextBox1.Enabled = True TextBox2.Enabled = False End If End...

Hi, So after working for couple of weeks my macro suddenly stopped working and keeps giving me a compile error. I also cannot create any new activex items anymore in my excel files. I heard there were an update on VBA? But I dont believe that would cause an issue like this? Is there also...

Morning, I'm brand new to this forum, and pretty new to Excel/VBA, so please be patient as I learn the lingo. My issue - I have created a userform that has a ComboBox with a pre-defined list, not to be changed. The macro runs without issue and will populate the specified row with the user...

I have set the Column Count to 2 in the properties window of the combobox, but when the code is the following ComboBox1.List = Sheet2.Range("EmployeeTable[Name]").value it only shows one column. I have tried doing this ComboBox1.List =...

Hi All, I have a combobox on a userform that i need to add values from a fixed range (With criteria), but i need it to do this across 4 sheets The Sheets are "WRS P1", "WRS P2", "WRS P3" and "WRS P4" Column A has a range of Dates (A8:A32) (This range has a formula in all cells within range...

Hi, i want to generate a mutiple line listbox at first i have 3 optionbutton selection that as i select one it gave me some diferent values at the first combo box selection. as example: optionbox(NORMAL) --> combobox(ppm) --> Textbox(1,5) optionbox(x) --> combobox(ppm) --> Textbox(1,2)...

Hi all, I'm trying to create a running search bar in my userform. Below is my code. SupplierInfo is the search list. wsSearch is a worksheet where the filtered list will be pasted to. Everything work until the result list only has 1 item. Then it would give an error message as in the attached...

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

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

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?

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

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

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

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

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