Results 1 to 7 of 7

Thread: Input Box with Drop down list

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    VBAX Tutor david000's Avatar
    Joined
    Mar 2007
    Location
    Chicago
    Posts
    276
    Location
    There is a handy constant for this also.

    Private Sub Userform_Initialize()
    Dim i As Integer
    For i = 1 To 12
        ComboBox1.AddItem MonthName(i)
    Next i
    End Sub
    Last edited by Aussiebear; 04-11-2023 at 04:19 PM. Reason: Adjusted the code tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •