VBA form data to specific cells

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
39,164
Office Version
365
Platform
Windows
Do you get any errors when you click the SaveWallBraceButton ?
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

MNFPGE

New Member
Joined
Mar 5, 2018
Messages
10
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
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
39,164
Office Version
365
Platform
Windows
Glad you figured it out & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,096,444
Messages
5,450,485
Members
405,613
Latest member
Arpit

This Week's Hot Topics

Top