+ Reply to Thread
Results 1 to 11 of 11

CELL change? Or not!

  1. #1
    Forum Contributor
    Join Date
    11-26-2014
    Location
    Bosnia&Herzegovina
    MS-Off Ver
    Office2013
    Posts
    323

    Arrow CELL change? Or not!

    Hello, dear Excel.... people!
    I have A1 C1 E1 in wich i'll manually enter numbers from 1 to 6 at time when i'll have 1 or 6 let's say, pills! Is it possible in Excel w/o VBA or File>Properties>Aditional properties>Book1-Properties...., to set some formula to write me in cell B1 every time when cell OR(A1,C1,E1) is changed, date&time when OR(A1,C1,E1) was accessed?! In need for formula when cell is double clicked not just value chanage, because, there will be times when OR(A1,C1,E1) is the same value as last time.
    Thanks for any help!
    Sorry if bad english1

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: CELL change? Or not!

    please google it:
    Private Sub Worksheet_Change(ByVal Target As Range)
    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Last edited by tim201110; 11-19-2016 at 12:46 PM. Reason: moderator request

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: CELL change? Or not!

    Not really understood.

    Right Click on your sheet name at the bottom of excel and paste this code in the VBA module that opens.

    Close the VBA module.

    Thats it.

    If you Make any changes, double click or select an cell the Macro InsertDate will run.

    If your Cell is A1, C1 or D1 then the date in B1 will change

    Please Login or Register  to view this content.

    B1 format must be custom type dd/mm/yyyy hh:mm:ss
    Last edited by mehmetcik; 11-19-2016 at 11:42 AM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: CELL change? Or not!

    Hi Tim,

    Sorry friend you forgot your code tags.

  5. #5
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: CELL change? Or not!

    not quite
    it was't a code, just a string for a search query

  6. #6
    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. 2501 (Windows 11 24H2 64-bit)
    Posts
    88,917

    Re: CELL change? Or not!

    Tim - your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    Please go back and edit post #2 to add code tags. Thanks.
    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  7. #7
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: CELL change? Or not!

    Quote Originally Posted by AliGW View Post
    Tim - your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    Please go back and edit post #2 to add code tags. Thanks.
    answered above

  8. #8
    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. 2501 (Windows 11 24H2 64-bit)
    Posts
    88,917

    Re: CELL change? Or not!

    Tim - the forum rules require that you comply with a moderator's request.

  9. #9
    Forum Contributor
    Join Date
    11-26-2014
    Location
    Bosnia&Herzegovina
    MS-Off Ver
    Office2013
    Posts
    323

    Re: CELL change? Or not!

    Peace be with you ALL, but, thanks for any help, Will not work on Windows Phone

  10. #10
    Forum Contributor
    Join Date
    11-26-2014
    Location
    Bosnia&Herzegovina
    MS-Off Ver
    Office2013
    Posts
    323

    Re: CELL change? Or not!

    Good old manual input(B1) is answer!

  11. #11
    Forum Contributor
    Join Date
    11-26-2014
    Location
    Bosnia&Herzegovina
    MS-Off Ver
    Office2013
    Posts
    323

    Re: CELL change? Or not!

    Is there VBA or non-volatile formula solution to monitor single or array of cell, to check has it value changed? Not just a value, even a double click register as value changed.

+ 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] Help with Worksheet Change command to change Cell value without pressing Enter key
    By rv02 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2016, 12:30 PM
  2. [SOLVED] Change On_Open macro to a cell change in a range of cells
    By davidpierce in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-27-2015, 02:46 PM
  3. If range value change, active cell equal date and time of change.
    By kmakjop in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2015, 02:43 PM
  4. auto change cell formula on condition of worksheet change in other cells
    By futurejock in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-01-2009, 12:11 AM
  5. [SOLVED] making copied cells change with change in original cell
    By Jennifer Mcdermeit in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2006, 11:58 AM
  6. Cell value change to trigger macro (worksheet change event?)
    By Neil Goldwasser in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2006, 10:00 AM
  7. [SOLVED] Change workbook sheet reference using cell A1 to change a vairable
    By Reed in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-20-2005, 04:06 PM

Tags for this Thread

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