Data Input Form question

Cyberseeker · #7 03-30-2017, 03:01 AM

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatically copy/paste a form field onto new pages, with user input included	Pindar	Word VBA	3	01-13-2017 11:49 AM
How to set font size in text-input field of protected form	UnicornVestibule	Word	5	06-06-2016 10:51 PM
My First Attempt at Form Creation: Input of Text via Check Box or Radio Button	tatihulot	Excel	0	08-15-2013 06:11 AM
Word only writes top half of input in form	Chippychap	Word	8	07-20-2012 12:49 AM
Data input in Powerpoint?	DeeDubb	PowerPoint	1	04-05-2012 01:53 AM