Excel_User_10k
Board Regular
- Joined
- Jun 25, 2022
- Messages
- 100
- Office Version
- 2021
- Platform
- Windows
I am trying to create a Clear/Reset button for an Order Form Sheet. It includes several Radio Button Group selections which reference cells on another Sheet so I need to refer to those cells in this Clear Button too in order to reset them to a default as well.
So far I have:
However, it only works with the first line for Cell Value change and not the rest. Not sure why?
I also have 2 drop down boxes. Is it possible to include a reset to these where it defaults back to "Select..."?
Thank You.
So far I have:
VBA Code:
Sub RectangleRoundedCorners3_Click()
Dim Sheet1 As Worksheet, Sheet2 As Worksheet
Set Sheet1 = Sheets("Submit Sale")
Set Sheet2 = Sheets("Products_Dec")
[COLOR=rgb(44, 130, 201)] [/COLOR][COLOR=rgb(0, 0, 0)]Sheet1.Cells(6, 6).Value = ""[/COLOR]
Sheet1.Cells(6, 13).Value = ""
Sheet1.Cells(6, 18).Value = ""
Sheet1.Cells(8, 18).Value = ""
Sheet1.Cells(10, 18).Value = ""
Sheet2.Cells(13, 3).Value = ""
Sheet2.Cells(13, 6).Value = ""
Sheet2.Cells(13, 7).Value = ""
Sheet2.Cells(13, 8).Value = 1
Sheet2.Cells(13, 9).Value = 1
Sheet2.Cells(13, 10).Value = 1
Sheet2.Cells(13, 11).Value = ""
End Sub
However, it only works with the first line for Cell Value change and not the rest. Not sure why?
I also have 2 drop down boxes. Is it possible to include a reset to these where it defaults back to "Select..."?
Thank You.