Forum Discussion

JoeCavasin's avatar
JoeCavasin
Brass Contributor
Jan 20, 2025
Solved

VBA: Input Box vs User Form Capabilities

Seeking advice on which of the title items seems like the most appropriate option for the criteria below. Preface also to say lots of folks on here have been incredibly helpful with all the VBA ques...
excel
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Jan 20, 2025

    Since users have to enter multiple items for each new or leaving user, I'd use a userform with text boxes to enter the information and command buttons to save the current information and to start over.

HansVogelaar's avatar
HansVogelaar
MVP
Jan 20, 2025

Since users have to enter multiple items for each new or leaving user, I'd use a userform with text boxes to enter the information and command buttons to save the current information and to start over.

  • JoeCavasin's avatar
    JoeCavasin
    Brass Contributor
    Jan 20, 2025

    Great, thanks again as always!

    Started building a user form, and just curious if user forms allow logic or triggers (for lack of a better word) which presents them on opening the workbook, so users are directed there first by default? 

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Jan 20, 2025

      Yes:

      In the Visual Basic Editor, in the Project Explorer pane on the left hand side, double-click ThisWorkbook under Microsoft Excel Objects.

      Copy the following code into the ThisWorkbook module, and if necessary, replace UserForm1 with the real name of your userform.

      Private Sub Workbook_Open()
    UserForm1.Show
End Sub

       

Resources