Nitehawkhp
New Member
- Joined
- Dec 2, 2016
- Messages
- 37
I need help creating a control button on my worksheet named 'Data Validation'. That will open a Userform named 'AdjustResetButtonForm' containing the follow code:
Thanks for any help.
Code:
TextBox1.Value = Sheets("Data Validation").Range("X3").Value
TextBox2.Value = Sheets("Data Validation").Range("X4").Value
TextBox3.Value = Sheets("Data Validation").Range("X5").Value
TextBox4.Value = Sheets("Data Validation").Range("X6").Value
TextBox5.Value = Sheets("Data Validation").Range("X7").Value
TextBox6.Value = Sheets("Data Validation").Range("X8").Value
TextBox7.Value = Sheets("Data Validation").Range("X9").Value
TextBox8.Value = Sheets("Data Validation").Range("X10").Value
TextBox9.Value = Sheets("Data Validation").Range("X11").Value
TextBox10.Value = Sheets("Data Validation").Range("X12").Value
TextBox11.Value = Sheets("Data Validation").Range("X13").Value
TextBox12.Value = Sheets("Data Validation").Range("X14").Value
AdjustResetButtonForm.Show