+ Reply to Thread
Results 1 to 7 of 7

automatic insert date without change in future with VB code

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

    automatic insert date without change in future with VB code

    dear
    i have problem with insert automatic insert date
    as in attached file i want to add date in I6 when i write value more than 0 in I2
    and repeat this from J2 to AF2

    and also want to repeat this with another in I8 (write any value more than 0 and date automatic insert to I12
    i already made it but it give me error as you can test .

    and the last request is
    in cell E2 have number (12 or 18 or 24 manual entry), my question is how i connect the number of cells from I4 to AF4 (meaning if in cell E2 write 12 its only allow to wrote function from I4 to T4 (meaning 12 cells only but if 18 its allow to Z4 and soon without change in function of this cells.
    hope you can understand me
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: automatic insert date without change in future with VB code

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 04-26-2016 at 02:00 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

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

    Re: automatic insert date without change in future with VB code

    Dear AlphaFrog
    thanks for your help and your effort
    would you please explain how can add extra cell in this sheet because i try to add more than ROW with the same function but dosn't work (meaning repeat this data in excel )
    if you can explain to me how can understand this formual you write i think i can add extra row or delete any row ?
    regards

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: automatic insert date without change in future with VB code

    Quote Originally Posted by mazan2010 View Post
    would you please explain how can add extra cell in this sheet because i try to add more than ROW with the same function but dosn't work (meaning repeat this data in excel )
    I do not understand what that means.

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

    Re: automatic insert date without change in future with VB code

    i mean as you see in attached file
    you make function for data in row 1:6
    and data in row 7:12
    i need to add extra row and apply this function on it as in attached file

    hope you understand me now
    Attached Files Attached Files

  6. #6
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: automatic insert date without change in future with VB code

    The code I gave does work for extra rows. The example file you gave does not have my code in it. It has other code that is not mine. Use my code and it will work.

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

    Re: automatic insert date without change in future with VB code

    ok thanks Alphafrog
    its work now

+ 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. How to change the row color depends on future date
    By alzaeem in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-04-2014, 02:24 PM
  2. Automatic Date insert
    By tregrad in forum Excel General
    Replies: 31
    Last Post: 05-24-2013, 12:38 AM
  3. automatic date insert
    By raksha jain in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2012, 06:33 AM
  4. Replies: 3
    Last Post: 02-13-2012, 03:20 PM
  5. Insert a future date based on a number in another cell
    By LongShanks in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-10-2010, 10:48 AM
  6. Replies: 1
    Last Post: 03-22-2010, 04:09 PM
  7. insert date, automatic calculate
    By Seroleh in forum Excel General
    Replies: 3
    Last Post: 06-02-2009, 11:17 AM
  8. [SOLVED] automatic insert date when clicking cel
    By Steve wildemeersch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2005, 11: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