Thread: [Solved] Data Input Form question
View Single Post
 
Old 03-30-2017, 03:01 AM
Cyberseeker Cyberseeker is offline Windows 10 Office 2010 32bit
Advanced Beginner
  
Join Date: Jun 2016
Posts: 44
Cyberseeker is on a distinguished road
Default
Thank you for your help so far. I have got into it successfully, and altered the values from ...

Code:
Private Sub ClearFormbutton_Click()
    Range("Calcs!AC11").Value = ""
    Range("Calcs!AC12").Value = ""
    Range("Calcs!AC13").Value = ""
    Range("Calcs!AC14").Value = ""
    Range("Calcs!AC15").Value = ""
    Range("Calcs!AC16").Value = ""
... to this. As you can see, I have different columns now.

Code:
Private Sub ClearFormbutton_Click()
    Range("Calcs!U11").Value = ""
    Range("Calcs!U12").Value = ""
    Range("Calcs!U13").Value = ""
    Range("Calcs!U14").Value = ""
    Range("Calcs!U15").Value = ""
    Range("Calcs!U16").Value = ""
However, when I operate it now, it continues to deposit information into column AC, as before? Am I missing doing something?
Reply With Quote