Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: VBA form data to specific cells
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    22,906
    Post Thanks / Like
    Mentioned
    385 Post(s)
    Tagged
    41 Thread(s)

    Default Re: VBA form data to specific cells

    Do you get any errors when you click the SaveWallBraceButton ?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 2003 & 2013 on Win 7

  2. #12
    New Member
    Join Date
    Mar 2018
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA form data to specific cells

    Got it! Code below was what worked. I assume it was closing the form before it was unloading. Thanks so much for your help!
    Code:
    Private Sub CarWallBraceUserForm()
    
    UserForm3.Show
    
    
    End Sub
    Private Sub CloseFormBtn_Click()
       Dim WS As Worksheet
       Dim Sizes As Long
       Set WS = Worksheets("Questions")
       With WS
          Cells(85, 3).Value = RailPosn1.Value
          Cells(86, 3).Value = RailPosn2.Value
       End With
    
    
    Unload Me
    End Sub

  3. #13
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    22,906
    Post Thanks / Like
    Mentioned
    385 Post(s)
    Tagged
    41 Thread(s)

    Default Re: VBA form data to specific cells

    Glad you figured it out & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 2003 & 2013 on Win 7

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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