you can use this code Private Sub CommandButton3_Click() Dim strng As String Dim lCol As Long, lRow As Long With Me.ListBox1 ‘<–| refer to your listbox: change “ListBox1” with your actual listbox name For lRow = 0 To .ListCount – 1 ‘<–| loop through listbox rows If .selected(lRow) Then ‘<–| if current row selected For … Read more
Try placing this code in the userforms code module: Option Explicit ‘API functions Private Declare Function GetWindowLong Lib “user32” _ Alias “GetWindowLongA” _ (ByVal hwnd As Long, _ ByVal nIndex As Long) As Long Private Declare Function SetWindowLong Lib “user32” _ Alias “SetWindowLongA” _ (ByVal hwnd As Long, _ ByVal nIndex As Long, _ ByVal … Read more
I sure hope the following piece of code is what you are looking for. Private Sub Textbox1_Change() Dim i As Long Dim arrList As Variant Me.ListBox1.Clear If TMP.Range(“A” & TMP.Rows.Count).End(xlUp).Row > 1 And Trim(Me.TextBox1.Value) <> vbNullString Then arrList = TMP.Range(“A1:A” & TMP.Range(“A” & TMP.Rows.Count).End(xlUp).Row).Value2 For i = LBound(arrList) To UBound(arrList) If InStr(1, arrList(i, 1), Trim(Me.TextBox1.Value), … Read more
There is [eternal] confusion surrounding the two types of controls available to Excel — exacerbated by the contrasting terminology used by different online sources. This is only a general overview of the differences between Form Controls and ActiveX Controls (based on my old notes that helped me finally figure out the differences!) Visit the included … Read more
This can be achieved by using a class module. In the example that follows I will assume that you already have a userform with some textboxes on it. Firstly, create a class module in your VBA project (let call it clsTextBox — be sure to change the ‘Name’ property of the class module!) Private WithEvents … Read more
Don’t declare the variable in the userform. Declare it as Public in the module. Public pass As String In the Userform Private Sub CommandButton1_Click() pass = UserForm1.TextBox1 Unload UserForm1 End Sub In the Module Public pass As String Public Sub Login() ‘ ‘~~> Rest of the code ‘ UserForm1.Show driver.findElementByName(“PASSWORD”).SendKeys pass ‘ ‘~~> Rest of … Read more
To add a control event dynamically in an Excel form; you need to first add the event(s) in a class module. For my example, I am going to add a class module named clsTEST with one event, btn_click() ‘#### CLASS NAMED clsTEST Public WithEvents btn As MSForms.CommandButton Public frm As UserForm Dim iCount As Long … Read more
Methods It’s always better to loop through an array than a range – it’s much faster. It’s even faster to create a variant data field array with a one liner instead of redimensioning a predeclared array and fill it in an extra loop as proposed by Siddharth Rout (though a good method 🙂 Note: The … Read more
Disclaimer I wrote the article Victor K linked to. I own that blog, and manage the open-source VBIDE add-in project it’s for. Neither of your alternatives are ideal. Back to basics. To select different filters I have differnt (sic) userforms. Your specifications demand that the user needs to be able to select different filters, and … Read more
Indeed, I’ve been focusing quite a lot on modal forms – because that’s what’s most commonly used. Thanks for the feedback on that article! The principles are the same for non-modal forms though: simply expand on the Model-View-Presenter pattern roughly outlined in the linked article and here. The difference is that a non-modal form needs … Read more