Private Sub Worksheet Change - Multiple on same worksheet

  • Re: Private Sub Worksheet Change - Multiple on same worksheet

    One more related question.

    The date stamp appears in my table and outside my table.

    First question

    Is there any way to limit the date stamp inside the table?

    See full code above...

    Here is an extract of the code portion of the date stamp

    Second question

    My table has data validation which limits the user input between 2 dates for some columns. I also have an input message telling the user how to enter the date when they click on the table column header. When I double click to change the column header title, I get an error with the following portion of the code :

    str = Right(str, Len(str) - 1)

    The error is Run-Time Error 5 : Invalid Procedure Call or Argument.

    I am still able to change the header title but this pop-up always bring me to the VBA debug or end options which is kind of annoying.

    Any way to fix this?

    Thanks! :)

  • Hi Everyone!

    Could you please help a complete newbie/dummy to combine these two separate codes please? I am a complete newbie and cannot seem to combine two separate codes together. Any help will be much appreciated!


  • Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

    All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

    How to use code tags

    Note: no apostrophe in the tags, just used for demonstration here.


    your code goes between these tags


    Or, just highlight all of the code and press the <> in the post menu above button to add the code tags.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!