Linked Questions

Intro: I am aware that - showing UserForms - it's best practice to handle QueryClose within the userform code (If CloseMode = vbFormControlMenu ...) doing no Unload Me therein, just a timid Me.Hide ...

I am trying to use a subroutine call a variable from a userform input. But, even though I can display the userform inputs correctly in the userform by printing it to the sheet, I can't seem to pass it ...

I've tried creating a form in the object-oriented manner as shown in this answer: https://stackoverflow.com/a/38382104/4460023. Upon closing the form, I'd like to refer to the object property ...

I am trying to add some code to have a userform pop up which allows the end user to input their login/password for s specific website. This code Passing variable from Form to Module in VBA got me ...

I have created a VBA UserForm which is essentially a glorified input box Just like an input box can be employed like this Dim returnVal As String returnVal = InputBox("Write some string") I would ...

I have a vast number of folders in my Outlook inbox. I have a macro which will list (in a listbox object) all the folders that have xxxx text in it. I then manually drill down into the folder ...

I have a UserForm with a ListBox for the user to select values. Those values are populated in UserForm_Initialize() via a function call to the base module, which returns an array as variant. This ...

I want to assign the inputs of a userform to variables in a new module once the user clicks submit. I have read the following post : Passing variable from Form to Module in VBA I believed I had ...

I'm new to VBA and and am trying to finish this project by teaching myself. I'm trying to make a userform with a ComboBox drop down menu of months and a textbox to enter the year. I then want to have ...

I have code where on the first try it works fine. The code ends with 710 Unload UserForm1 730 Unload UserForm2 On the first round, these trigger: Private Sub UserForm_QueryClose(Cancel As ...

If have a function that loops through a selection of emails, an email is an object not a lose variable (Passing variable from Form to Module in VBA): Private Sub CommandButton5_Click() For Each ...

I am currently designing a project with a windows form. I am also creating classes that I want to interact with this form. Instead of passing through the form to each object I create, is there a way ...