combobox

Good Morning Everyone, Looking for some recommendations on how I could prevent the RunTime Error 1004 while running VBA for an AutoFilter routine. In the work sheet I have a ActiveX Combobox that is being used to select a value. I would then like to filter records in a range of "A15:F" & LRow...

Hello, I'm creating a User Form and trying to get the starting position of a Combo Box to be the number of the month. For example since it is currently July I would like the Combo Box to start on position 6. When I try this varToday = Date varToday = varToday - 10 'this is purposeful...

I use osk.exe on my tablet when using a combobox. If I close the on-screen keyboard application in the midst of typing in the combobox, the combobox gets buggy. I can open the on-screen keyboard again but it will not show what I am typing in the combobox. I open the osk.exe application by...

Hello Wizards, I thank you for any future help in advance. I have a userform with multiple comboboxes and some of them are used for the same purpose. By that I mean these comboboxes use the same dynamical named range as rowsource. I want to stop the user from duplicating a combobox twice, so...

Is there a way to initiate commands when a combobox is activated? In other words, if the cursor does not appear in a combobox, but then the combobox is clicked and the cursor populates the combobox, can I have commands run? I am not looking for ComboBox_Change, I am more looking for something...

I have a userform that I load but the combobox is selected... I don't want the cursor blinking in my combobox when the userform is opend. I currently use sendkeys for Tab as it will move the selection to the next button which is fine. Is there a different way to code this rather than having to...

Using windows 10 on a tablet and would like to have the onscreen keyboard automatically pop up when I click on a combobox in my user form. Any ideas?

Hi, Can you give some pointers please. I have a userform on a worksheet then opens automatically when you visit the page. Ive looked for this set focus code but dont find it anywhere. Can this be written another way as opposed to set focus. I just cant seem to find where its being controlled...

Hi Friends, I have a Userform with a combobox "cmbchart" and i have a sheet with some charts , "Charts". In the comboBox there should be 3 Chart type listed, Column Chart , Bar Chart, Line Chart . Based on the user selection my chart in "Charts" sheet should be changed (Column,Bar,Line...

Hi Friends, I have a User form with a comboBox caled "cmbpivotvalue" . When i press Submit/validate button "cmbValidate" in the userform , the values in this comboBox should go to the "VALUES" section on the PivotChartFields (please refer the screenshot) . Please help me to create code for...

Hi Friends, Example : www.imgur.com/2lAUMdM Please see this image as example. I have a combobox called "cmbpivotvalue" in my Userform. I want " A1,A2,A3,A4,B1,B2,B3,B4,C1,C2,C3,C4 " as values in my combobox dropdown (Refer the example) . Basically I want the heading name + values under that...

Hi Friends, I have a combobox in User form where the data is taking from a sheet called "Inconsistency Order" and the combobox name is cmbSelChartAttr . I have so many values in the droplist. The values which ever is having a string "- check" in the end , It should not be added to the combobox...

Good day all, I have a simple issue that I am struggling to resolve. In an access report I have a combobox (Called "InterestCode") that looks up a value from a query and outputs that value. There are a number of options , eg. M1, M2, M3, P1, P2 etc. Depending on this value, I would like...

Hello Gurus, I am currently having trouble making my ComboBox ActiveX hide and unhide columns based on range of text in a row. I did not have an issue with the formula when it used to be a dropdown, but when I tried to convert using the ComboBox, I am having issues. What I would like this...

Hi, is it possible for the combobox.list to not show duplicates? Here's the code I have... Private Sub UserForm_Initialize() Application.ScreenUpdating = False With Worksheets("Input new run") Me.cmbDelLH.List = .Range("B7", .Range("B7").End(xlDown)).Value Me.cmbLegDel.List =...

Hello, I have created a user form that lets me enter data onto different worksheets within the workbook depending on a combobox selection. My problem arises when I click the command button to open the 2nd user form. It opens, but the combobox does not display the entries I want to Show. Sub...

I have a combo box on a userform that is connected with a formula. It's similar to an autocomplete combo box. Anyways, I have my program working fairly smoothly except for the fact that after it narrowing down my search, I will click on SOME options and it clears itself and it wants me to type...

Hello I would like to search values of Combobox Column values For eg typing J in comboBox column 1 it should dropdown the list with all J and respective range in column2 Now if i type A or D or : in column 2 dropdown list to display all the names and and range if typed Specificaly the Range...

My laptop Office suite has been recently updated. Office, i.e., Excel, in my virtual workspace has not been updated yet. My ComboBoxes in identical files only function completely in my virtual workspace where Office updates have not taken place. I copied a file over to my laptop (updated Excel)...

Upon mouse hovering, the combobox will automatically drop down the list. Upon mouse leaving region of combobox, the list will automatically scroll up. The first task can be done using combobox.dropdown. However, how to handle second task? Any ideas? Private Sub ComboBox1_MouseMove(ByVal...