Results 1 to 8 of 8

Thread: create invoice with user form

  1. #1
    Junior Member
    Join Date
    Jan 2018
    Posts
    6
    Rep Power
    0

    create invoice with user form

    sir,
    i am create a create invoice user form & i am insert the vba code but this vba code was not working correctly, in this user from invoice no was auto generate, the cgst & Sgst tax rate was calculated than i am choose gst rate, & than i am choose customer name in BILL TO Frame & click on the copy command button the customer name was show on the SHIP TO Frame, than i am add new customer name , the customer name was save on customer excel sheet, in Description Frame Textbox 2 Sr. No was auto generate,Combo box 1 choose description of items & service ,Textbox 3 hsn code was auto generate,Textbox 4 uom was auto generate,Textbox 5 quantity was add manually,Textbox 6 item rate are add manually, Textbox 6 amount was auto calculate,Textbox 8 discount was add manually,Textbox 9 taxable Amount was auto calculate,Textbox 10 CGST% was auto calculate with GST Rate, Textbox 11 CGST Amount was auto calculate ,Textbox 12 SGST% was auto calculate with GST Rate, Textbox 13 SGST Amount was auto calculate ,Textbox 14 Total Amount was auto calculate,Labal 18 Show Product Balance, Textbox 15 Auto Round of Total amount,Label 21 Show Total Amount, Combo Box 2 How Reverse Charges options "yes", "no",And click on the add button the data was show on the Listbox 1, & add the Vehicle no in Textbox 16, Add electronic Reference no in Textbox 17,add note in Textbox18 And Click on the Create Command Button All the Data was show On the Sale Invoice excel Sheet Sir, I am send the attachments sir
    Attached Files Attached Files

  2. #2
    Junior Member
    Join Date
    Jan 2018
    Posts
    6
    Rep Power
    0
    the confirmed mail was not in the my gmail account inbox sir, please resend the mail sir

  3. #3
    Junior Member
    Join Date
    Jan 2018
    Posts
    6
    Rep Power
    0
    reply sir

  4. #4
    Junior Member
    Join Date
    Jan 2018
    Posts
    6
    Rep Power
    0
    reply sir, i am waiting for your answer sir

  5. #5
    Junior Member
    Join Date
    Jan 2018
    Posts
    6
    Rep Power
    0
    iam not understand sir please resolve this sir

  6. #6
    Moderator
    Join Date
    Jul 2012
    Posts
    156
    Rep Power
    12
    Cross-posting without Links.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this http://www.excelguru.ca/content.php?184 to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

  7. #7
    Junior Member
    Join Date
    Jan 2018
    Posts
    6
    Rep Power
    0
    yes i am cross post this sir, please solve this sir & send the vba code sir

  8. #8
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,270
    Rep Power
    10

    I try do explain Cross Posting I did do it have

    Sir,
    I am unable to solve your problem. Sorry. This answer I do not know.
    _._____________________________

    But I can help try to explain .. “Cross Posting

    You may ask question in more that one Forum
    You have asked the question in two Forums:
    excelfox.com
    And
    excelforum.com

    This is permitted, But Only if you include URL links to all cross posts:
    You most copy URL and Paste in Post #1
    _.____________________

    For example:
    This, sir, you must do, please

    _ Got to Post #1 and Edit Post
    Post_1_Edit_Post.jpg https://imgur.com/TEvtVsV
    Edit_Post_1.jpg https://imgur.com/8akM3KW
    Edit_anul21_Post_1.jpg https://imgur.com/p9Dxx2d

    _ Add _
    Sir, I do also cross Post here:
    https://www.excelforum.com/excel-programming-vba-macros/1218697-create-invoice-with-user-form.html
    I did.

    Sir_I_do_also_cross_Post_here_I_did.jpg https://imgur.com/zJ1dgTx

    ( URL_From_excelforum.jpg https://imgur.com/LTgjY2P )


    _ Save
    Save_after_Edit_I_did_do.jpg https://imgur.com/QWFuuC0

    _....
    Then this is good :-
    Finished.JPG https://imgur.com/DAcWT2A


    _._______________________________
    Is this you this understanding?
    Or Hindi???
    हिंदी
    https://www.excelforum.com/word-form...ml#post4815481




    Alan
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
    Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!

Similar Threads

  1. Inserting Image In VBA User Form Caption
    By littleiitin in forum Download Center
    Replies: 3
    Last Post: 02-22-2021, 03:07 PM
  2. VBA Code for User Form
    By dkesar in forum Excel Help
    Replies: 1
    Last Post: 01-02-2015, 03:19 PM
  3. Replies: 5
    Last Post: 06-13-2014, 08:37 PM
  4. Create Invoice From Flat Data Range
    By johnreid7477 in forum Excel Help
    Replies: 4
    Last Post: 08-19-2013, 11:41 AM
  5. Adding A Menu Bar To A User Form
    By Rasm in forum Excel Help
    Replies: 14
    Last Post: 05-05-2011, 04:05 AM

Posting Permissions

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