+ Reply to Thread
Results 1 to 6 of 6

modify code that show last value in row to add 1

  1. #1
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    modify code that show last value in row to add 1

    dear Sir
    here my code that show last value in column A in database sheet
    HTML Code: 
    i would like to add to this code that enable enter value in textbox2 which consist of value of textbox1 +1
    for example
    if last row value is 37
    textbox1 show 37
    and textbox2 show 38

  2. #2
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: modify code that show last value in row to add 1

    dear all i found solution for this online as the following in my photo
    HTML Code: 
    Attached Images Attached Images

  3. #3
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: modify code that show last value in row to add 1

    but the problem that can't find how can make concatenate two textbox in one like { 13/2017 }

  4. #4
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: modify code that show last value in row to add 1

    i found this but still without this sign / and without {}
    HTML Code: 

  5. #5
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: modify code that show last value in row to add 1

    many thanks for all and i just try many code and find the following solution is working and i post for all
    HTML Code: 

  6. #6
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: modify code that show last value in row to add 1

    many thanks for who try find solution for me like Glenn Kennedy and other that browse my post

+ 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] Modify Macro to show company's color palette
    By IronCladRooster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2014, 11:57 AM
  2. [SOLVED] how to add counter in msgbox to show remain times the message will show vba code
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-25-2013, 06:46 AM
  3. [SOLVED] Help to modify vba code
    By christopherjward in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2013, 06:56 PM
  4. [SOLVED] Array Formula vs vBa code - How To Modify My Messy Code To One Of Those
    By ScotyB in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-20-2012, 12:04 AM
  5. Modify code to show message box on duplicate entry
    By twofootgiant in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-24-2011, 07:50 AM
  6. Modify code
    By swalsh19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2007, 02:25 AM
  7. Modify code in UDF
    By Biff in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-31-2005, 12:05 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