+ Reply to Thread
Results 1 to 4 of 4

VBA code for an incomplete listView

  1. #1
    Registered User
    Join Date
    09-17-2015
    Location
    Evreux, France
    MS-Off Ver
    2016 Fr 64 Bits
    Posts
    6

    VBA code for an incomplete listView

    Unable to post a new topic.

    My file is in Attachments
    and my topic is:

    Hello forum,
    Happy New Year to you all
    I tried to solve my problem, but I turn around.
    I am beginner in VBA and I'm not at all métrise the ListView.
    I attach my file

    That's my concern:

    For the first part of my message: Instant Payment Method

    COMBOBOX: the frame of the corresponding payment appears and textboxs "AMOUNT VAT, INCREASE, THE REMAINING, THE DATE OF THE DAY".

    We return the missing information which will fill the table SUIVI_DES_FACTURES. A check is performed to verify that the textboxs not be empty.

    A VALIDATION, the information in the square of the sheet RED "SUIVI_DES_FACTURES" are met.

    Already known to fill in the information textboxs
    E (5) Amount TTC TextBox17, TextBox24, TextBox38, TextBox46, TextBox54
    G (7) Increase TextBox18, TextBox25, TextBox39, TextBox47, TextBox55
    H (8) Remaining From TextBox19, TextBox26, TextBox40, TextBox48, TextBox56
    J (10) Date of Regulation (TextBox21, TextBox28, TextBox42, TextBox50, TextBox58) = TODAY

    The information in the Red Square are unknown at this time:
    Y (25) Method of payment: CASH, CHEQUE, BANK TRANSFER, PAYPAL, CREDIT CARD
    Z (26) Account Holder TextBox22, TextBox29, TextBox43, TextBox51
    AA (27) No check or Domicile TextBox23, TextBox30
    AB (28) Transaction TextBox44, TextBox53
    AC (29) Wording or Email address TextBox31, TextBox45, TextBox52
    AD (30) Bank Code TextBox32
    AE (31) Code Guichet TextBox33
    AF (32) Account number TextBox34
    AG (33) Key RIB TextBox35
    AH (34) BIC / SWIFT TextBox36
    AI (35) IBAN TextBox37
    AK (37) Payment Cash TextBox20, TextBox27, TextBox41, TextBox49, TextBox57

    Sincerely

    LaurentMode de paiement Immédiat.xlsm

  2. #2
    Registered User
    Join Date
    09-17-2015
    Location
    Evreux, France
    MS-Off Ver
    2016 Fr 64 Bits
    Posts
    6

    Re: VBA code for an incomplete listView

    Please Login or Register  to view this content.
    Learning is endless

  3. #3
    Registered User
    Join Date
    09-17-2015
    Location
    Evreux, France
    MS-Off Ver
    2016 Fr 64 Bits
    Posts
    6

    Re: VBA code for an incomplete listView

    Dans cette listView les factures dites validée apparaissent en vert et la frame paiement correspondante à la facture sélectionnée doit être obligatoirement remplie.
    Pour les factures dite "en attente",nous validons cette facture par une liste déroulante type (ComboBox), les moyens de paiements possible ou par une facilité de Paiement type (CheckBox). COMBOBOX: le frame du paiement correspondant s'affiche et les textBoxs "MONTANT TTC, MAJORATION, RESTANT DU, LA DATE DU JOUR".
    Nous rentrons les informations manquantes qui les remplirons le tableau SUIVI_DES_FACTURES. Un contrôle s'effectue pour vérifier que les textBoxs ne soient pas vide.
    A la VALIDATION, les informations dans les carrés ROUGE de la feuille SUIVI FACTURES sont remplies.
    Information déjà connus à remplir dans les textBoxs

    Private Sub CmdB_Valider_Click()

    merci de me guider

    cordiament
    Laurent
    Last edited by trolldu27; 01-12-2016 at 01:22 PM.

  4. #4
    Registered User
    Join Date
    09-17-2015
    Location
    Evreux, France
    MS-Off Ver
    2016 Fr 64 Bits
    Posts
    6

    Re: VBA code for an incomplete listView

    Please Login or Register  to view this content.
    amicalement

    laurent

+ 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] How to add multiple cells in VBA code & prompt with msgbox when cells incomplete
    By SChapman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2013, 08:06 AM
  2. [SOLVED] Change code to be used to populate listview
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2013, 05:49 PM
  3. Converting listbox code to work with Listview
    By gsurge in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2012, 01:00 PM
  4. Listview checked row delete line in Listview and in worksheet data
    By madforit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2012, 01:00 PM
  5. Incomplete Range
    By sglick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2007, 04:49 PM
  6. [SOLVED] oldest incomplete job
    By floridasurfn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2006, 01:45 PM
  7. incomplete code
    By tim64 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-20-2005, 08:05 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