+ Reply to Thread
Results 1 to 6 of 6

Add & Clear Button vba code

  1. #1
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Add & Clear Button vba code

    R/ sir
    i am create a vba code for (Add & clear) Button but This code Will not work in my Sheet i am click on the Add & clear Button the massage was displayed "please fill on the all cells!) please correction in this vba code, Balance, Advance, Due Date, No of Days was fill on the customer requirement if is this was blank, sale date & sale inv. No was not clear click on the Add & Clear Button
    Click on the Add & Clear button The Old Sale Invoice No was Clear & new Sale Invoice No was Genrate
    i am insert the formula in B10 Cells (=IF(ISERROR(MATCH($B$9,Customers!A:A,0)),"AllCustomers",IF(INDEX(Customers!C:C,MATCH($B$9,Customers!A:A,0))="","",INDEX(Customers!C:C,MATCH($B$9,Customers!A:A,0)))) This Formulla Was working fine but Another cells B11(Show Address line1 & address line2),B12(show City, state, Zip Code) , B13(show Country , E-Mail) , B14 (Show Phone, Mobile, Fax) in thease Cells this formula was not working

    Please see the attachments & vba code than correct this vba code
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Add & Clear Button vba code

    The "please fill in all the cells" message appears because you have blanks in E10:E13. If you don't want those cells to be required, remove them from your mycopy variable.
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

  3. #3
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Add & Clear Button vba code

    R/Sir
    Please correction in this vba code
    ERROR 1:- Than click on the Add & Clear Button ignore (E7,E9,E10,E11,E12,E13)OR (A18 TO J23) if these Cells blank,
    ERROR 2:- I am click on the Add & Clear button than A28 cell was display a System Date & Time & B28 Cell was Display a System Name,Example:- A28 cell display sale date On(C4)Cell & A28 Cell Display a Sale inv. no on (C5)Cell
    ERROR 3:- I am click on the Add & Clear button the old Sale Inv. No. was Clear on C5 Cell & new Sale Inv. No. was Genrate in C5 Cell
    ERROR 4:- if sale 3 itmes Display Like this Please see The Attachment or If sale single item for different customer See the Attachments Example : Surinder gupta Paurchase A 3 items or Boe Peep Purchase a 1 item please see the attachment & see A28 or A31 cells
    ERROR 5:- Than i am click on the Add & Clear button all the call was display & past as its see the attachments
    ERROR 6:- i add Vba Code (mCopy "C4,C5,B9,B19,A18,A18,D19,E19,F19,G19,E5,E7,E9,E10,E11,J19,E4,E12,E13,E14,L21)"all cells number some shortcut for add A18 to J23 cell& ignore H18,H19,H20,H21,H22,& H23 CELLS

    respected sir i am resend the attachment please see the attachments
    Thanking you
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Add & Clear Button vba code

    ERROR 7:- C4,C5, E11,E12,E13,H18,H19,H20,H21,H22,H23 Clear The Contents But not Formula

    Sorry & Correction Inthis VBA Code

    Thanking you

  5. #5
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Add & Clear Button vba code

    I'm afraid that translating your request into something I can understand is going to be more of a challenge that I am willing to take on. Perhaps someone else can give it a try. Sorry.

  6. #6
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Add & Clear Button vba code

    plase correction this vba code

+ 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] Userform button action - clear,copy paste and print crashes. Please help with code
    By intex in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-05-2014, 12:16 PM
  2. [SOLVED] Clear button, add warning dialogue box that asks: Are you sure you want to clear?
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-21-2012, 02:41 PM
  3. Add a clear values code to command button
    By titantough in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-14-2011, 01:15 AM
  4. Button to clear sheet and automatic clear rows
    By sandbach in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2010, 02:06 PM
  5. Code for a Clear Form Button
    By Sep280 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2008, 03:30 PM

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