combobox list

So i have multiple comboboxes in a worksheet. Is there a way i can fill all of them with the same listfillrange? The code for that for one combobox would be: Private Sub ComboBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Set col =...

Hi there guys, hope that you're all well. I'm writing to you to ask you for help to create \ develop some macro base on combo box and click button that allows me to create a PDF based on some selection (criteria) that should be defined by me, previously (prompt, combo box, other suggestion)...

I have a separate method for database query. But I dont know how to connect it with combobox items? Whereas, if I select Combobox1 item1 it will direct to query and on button click will execute query. I tried putting it in Select Case, but not working. Thank you!

Hi, im trying to get the value from the combo box to filter the data in sheets as i dont use userform. but the combobox value cant be detected. i didnt know if i dont declared it as string or because of the value inside the combo box is too long. i used 2 code to add value in combo box (array &...

Hi All, This is probably very obvious, but I can't figure it out. I have a combobox pull down list that was working great until I added another item to the list. The list source is a formula, and that is working perfectly. But the combobox drop down feature did not add an additional row to...

I need help with a project, I have a Userform that I am using as an alternative to the Sort and Autosort options on a Worksheet. The reason I am using a UserForm is because the Worksheet needs to be protected from any unintentional removal of data. The UserForm has 8 option buttons, a Label for...

Hi All, I have encounter an error, while using dynamic data validation list, and adapt it to combobox list. it only works for only common data validation list. the list placed on different sheet : for the dynamic data validation list, I'm using formula ...

Guys, I was busy with some project and found bits and pieces VBA codes by which I made below code more useful and thought of sharing. Add below code in UserForm_Initialize Private Sub UserForm_Initialize() Dim LastRow1 As Long, LastRow2 As Long Dim Ws1 As Worksheet, Ws2 As Worksheet Dim v1...