VBA form data to specific cells
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
    27,051
    Post Thanks / Like
    Mentioned
    461 Post(s)
    Tagged
    46 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 365 on Win 10

  2. #12
    New Member
    Join Date
    Mar 2018
    Posts
    8
    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
    27,051
    Post Thanks / Like
    Mentioned
    461 Post(s)
    Tagged
    46 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 365 on Win 10

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
  •