.additem

Good Morning, The code below loads the data into my userform with no issue, but I need to load the userform and have the combobox1 options load also straight away instead of basing the combobox1 data on a change of the userform once its loaded. I am confused on how to get this to work? Should...

I am attempting to build an interactive document where users can pick from a drop down and a display would show up based on the item picked from the drop down. Sub ComboBox1_Change() ‘this would be the drop down menu for the user to choose from. With ComboBox1 .AddItem "AA" .AddItem...

Is there a more efficient way I can add numbers from 1 to 50 to a Userform Combobox rather than having to use '.AddItem' for each number?

Hi all, I would like to run a userForm with a specific name from a Module. Here is the code for my userForm. Public Sub UserForm_Initialize() 'Adding the Options for fileDecision comboBox With fileDecision .AddItem "Append" .AddItem "Copy" End With...

When I try to test this code, I'm getting an Error Type 13, but I haven't been able to find where there's a data mismatch. Thoughts? Option Explicit Dim coboDict As Object Private Sub cmd_Close_Click() Unload Me End Sub Private Sub cmd_Submit_Click() Dim ws1 As Worksheet Dim LastRow As...

Hi, I'm using the following code to populate a ListBox: LR = Sheet2.Range("D" & Rows.Count).End(xlUp).Row With lbxTest .Clear For i = 1 To LR .AddItem Sheet2.Range("D" & i).Value Next i End With On occasions, column D of Sheet2 will be...

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, I'm having a bit of a problem getting a combo box to do what I'd like. Esscentially what I want is the combo box to read the text box above called "accnumber" and check the first 2 characters. If they show "CA" then the box should only show "Mobile" else 2 other options. With system...

I am working with a userform and trying to load a combobox with values upon initialization. Below is the code i am trying to use which is just supposed to reference a sheet containing the values I want to use. The below code keeps giving me the error: "Run-time error '1004' Application-defined...

I am trying to create then populate combobox with values from a collection. Seems simple enough but keeps it keeps crashing when I try to do anything like .clear or .additem. What am I doing wrong here? Thanks. ' create the box Sheets("thesheet").Cells(1, 2).Select...