+ Reply to Thread
Results 1 to 10 of 10

UserForm not Displaying Correctly

Hybrid View

Strugglin UserForm not Displaying... 01-29-2009, 05:24 PM
Leith Ross Re: UserForm not Displaying... 01-29-2009, 05:43 PM
Strugglin Re: UserForm not Displaying... 01-30-2009, 05:32 AM
Leith Ross Re: UserForm not Displaying... 01-30-2009, 05:35 AM
Strugglin Re: UserForm not Displaying... 01-30-2009, 06:11 AM
royUK Re: UserForm not Displaying... 01-30-2009, 06:54 AM
Strugglin Re: UserForm not Displaying... 01-30-2009, 11:19 AM
royUK Re: UserForm not Displaying... 01-30-2009, 11:41 AM
Leith Ross Re: UserForm not Displaying... 01-30-2009, 06:59 PM
Strugglin Re: UserForm not Displaying... 02-01-2009, 09:02 AM
  1. #1
    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
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ Reply to Thread

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