Results 1 to 10 of 10

UserForm not Displaying Correctly

Threaded View

  1. #9
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: UserForm not Displaying Correctly

    Hello strugglin,

    OK, I got it working. There were a few errors. Here is the macro for the "Add Contact" button. I removed the code to hide the UserForm. Let the user dismiss the form when they ready.
    Private Sub CommandButton1_Click()
    
        'AddContract.Hide
        
        With Worksheets("Sheet1")
          StartRow = 3
          NextRow = .Cells(Rows.Count, "A").End(xlUp).Row + 1
          NextRow = IIf(NextRow < StartRow, StartRow, NextRow)
          .Cells(1, 10).Value = Me.DTPicker1.Value
          .Range("A1:M1").Copy _
            Destination:=.Cells(NextRow, "A")
          .Range("A1:M1").Clear
        End With
            
    End Sub
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1