Closed Thread
Results 1 to 7 of 7

VBA code for cheque printing

  1. #1
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    VBA code for cheque printing

    There is VBA code in attached file that code is for cheque printing purpose but that code is password protected and provided
    by third party so we could not do changes in that , i want same code or like that for cheque printing
    in that code which i attached problem is date not printing in proper format i do not need .(dot) in date
    currently date printing like 25.12.19 i want like 25 12 2019 and also be remember one good thing in this current VBA code is that
    once we print cheque by name like "Arnold Abram" it remember that name in history and we can reuse that name .
    VBA code create list of names which we printed cheque by that names.
    Last edited by AliGW; 12-23-2019 at 06:08 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483

    Re: VBA code for cheque printing

    The vba projects are protected, we can't get into it.

  3. #3
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Re: VBA code for cheque printing

    It just provided for example forget it and make your own code , which file attached we could not see VBA code of that file but we can use that code purpose of attaching that file only show you format of cheque and how that code work and what output it gives you, so make your own code for Bank cheque printing

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483

    Re: VBA code for cheque printing

    Please provide a sample workbook that somebody can work with.

    In that workbook, please provide the userform and the code you need help with.

  5. #5
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Re: VBA code for cheque printing

    I attached a file it is not very perfect but i hope it help you to create a code
    Last edited by AliGW; 12-23-2019 at 06:09 AM.

  6. #6
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,305

    Re: VBA code for cheque printing

    The UserForm code would be useful, my crystal ball is not working today

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,091

    Re: VBA code for cheque printing

    We cannot help with amendments to proprietary code and/or user forms that have been 'ripped' from a password protected workbook, sorry.

    Thread closed.
    Last edited by AliGW; 12-22-2019 at 07:34 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Batch Print cheque from form template
    By seolann in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-24-2019, 04:47 AM
  2. Need Cheque Writing Template In MS Excel
    By tariqjahangir in forum Excel General
    Replies: 3
    Last Post: 06-11-2019, 09:49 AM
  3. [SOLVED] Stale cheque calculation
    By dharmang1910 in forum Excel General
    Replies: 2
    Last Post: 06-05-2016, 08:14 AM
  4. Spell Number With Writing a Cheque Word
    By magic_ma in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2016, 10:19 PM
  5. Pay Invoice Via Printed Cheque.
    By D_Rennie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2009, 09:05 AM
  6. Cheque filling software
    By JK in forum Excel General
    Replies: 1
    Last Post: 11-08-2005, 10:25 AM
  7. Matching cheque payments to invoices
    By Eddie in forum Excel General
    Replies: 6
    Last Post: 05-18-2005, 02:06 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