Top "Userform" questions

Passing variable from Form to Module in VBA

I have the following button on a Form: Private Sub CommandButton1_Click() Dim pass As String pass = UserForm1.TextBox1 Unload …

excel vba module userform

Excel VBA Open workbook, perform actions, save as, close

This question has been edited due to lengthy comments and updates from proposed answers. As requested here is module 13; Sub …

vba excel automation userform

Calling UserForm_Initialize() in a Module

How can I call UserForm_Initialize() in a Module instead of the UserForm code object?

excel vba module userform

Adding controls to a frame in an Excel userform with VBA

I need to create labels and buttons dynamically and then add them to a frame within a userform. How do …

vba excel userform

In an Excel UserForm, how do I update a label's caption?

I created my first modeless UserForm in Excel and put an ActiveX label on it. How do I set the …

excel vba label caption userform

Hide close [X] button on excel vba userform for my progress bar

I created a userform to show a progress bar when the macro is still importing sheets The problem is the …

excel userform vba

Assign on-click VBA function to a dynamically created button on Excel Userform

I'm creating buttons dynamically on an Excel userform with the following code: With Me.CurrentFrame.Controls.Add("Forms.CommandButton.1") .Caption = "…

excel vba event-handling userform

Why does Showing a UserForm as Modal Stop Code Execution?

The following VBA code stops at Me.Show. From my tests, it seems that Me.Show stops all code execution, …

vba modal-dialog userform

Excel - VBA : pass variable from Sub to Userform

I have read and applied solution I found on similar topics but nothing seem to work in my case. So, …

excel vba variables userform

How To Display Part of Excel on VBA Form

I have a file on .csv format and from A-S columns, it has some records like a table. My complete …

excel excel-2007 userform vba