+ Reply to Thread
Results 1 to 3 of 3

VBA issue with form clearing

  1. #1
    Registered User
    Join Date
    02-02-2015
    Location
    Hucthinson
    MS-Off Ver
    2013
    Posts
    7

    VBA issue with form clearing

    Fellas,
    I'm hoping to get some assistance with a delivery spreadsheet I have downloaded and manipulated to fit my needs for fuels delivery records. The input sheet which is the first tab is saving VBA code when you "new" or "submit" but not when you "change" or "delete". Some of the problem code be the mixture of excel formulas and VBA but I am just beginning to use VBA and have not made any of my own sheets yet. I hope to learn but I am running out of time.

    I was wondering if anyone is willing to help me out, I am willing to work outside the forums if you would like.

    See below 2222 Propane deliveries ticket sheet-Good 22222.xls

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: VBA issue with form clearing

    What do you need help with?

  3. #3
    Registered User
    Join Date
    02-02-2015
    Location
    Hucthinson
    MS-Off Ver
    2013
    Posts
    7

    Re: VBA issue with form clearing

    I can't figure out the VBA code to protect the input information from disappearing in the first sheet when I use the Delete and Change buttons.It isn't doing it on the new and submit buttons. I have tried adjusting the ranges and changing VBA code ranges as well but I'm not familiar enough with how to do that or what to recognize is the issue.

    I need to roll the acct # and prices onto a new form with out deleting formulas or code.

    Any help would be greatly appreciated.
    Thanks2222 Propane deliveries ticket sheet-Good 22222.xls

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to filter data clearing issue
    By kingsp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2014, 09:08 AM
  2. Issue clearing combobox on change
    By TonyFurioso in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-01-2013, 03:51 PM
  3. [SOLVED] Clearing part of a form
    By sunswan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2013, 03:03 PM
  4. Clearing a Form
    By blanch2008 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2007, 11:26 AM
  5. Issue clearing previous selection
    By nmutimer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2006, 08:31 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1