Trying to have two events in the worksheet change code

[shermanwar]

Hi,
Very much a newbie but trying to get two different bits of code to run in the worksheet code.

As is now the worksheet change reads as below the dashed lines:

----------------------------------------------------------------

Please Login or Register  to view this content.

_____________________________________________________________________

But I want to add this to run there as well:

Please Login or Register  to view this content.

I have tried to copy other solutions to combine them but when I do I cant make them work. Any help really appreciated! This my first post so I apologize if I posted this incorretly. Thanks
Sherman

[JLGWhiz]

If you click Edit on your post, then select the part that is code and click the pound symbol (#) in the tool bar, it will add code tags so your code will retain its formatting and appear in a box like below.

Try this to see if it does what you want with the worksheet change event.

Please Login or Register  to view this content.

[shermanwar]

JLGWhiz, Thank you VERY much for teaching me that! I think knowing that will help me explain what I am trying to do. Much appreciated! Now that I have it formatted correctly would you mind taking another look? The code in the second window is for creating a data bar in cells with a format based on being positive or negative numbers. I didnt see it in your answer (again because it I didnt know how to post it right) Thank you again for your help!!!

[JLGWhiz]

The code in post #2 combines your two Worksheet_Change event macros and should do what you want. Did you try it?

The 'TwoColours' code would need to be in module1 for it to work properly.

[shermanwar]

Hi, The time format part works just fine but the part I couldn't get to work was making the time format and the Twocolours code both work. I inserted the code and created Module 1 for the Twocolours code. As before the time format works fine but the twocolours code does not appear to run.

Thoughts?

And again Thank you for helping me!!

[shermanwar]

Hi again! I made one small change of adding a the Call command and now it works in that any time I enter the time in one of time format cells its runs the data bar format update. That's very close to total success! Is there a way to make twocolours only fire when cells that effect it change (vice any time format cell)? That is to say there are a lot of cells that are covered by the time format code but only a few for that twocolours really apply to.

Please Login or Register  to view this content.

[JLGWhiz]

Please Login or Register  to view this content.

If the target cell being changed is in the range with red font, then the TwoColours code should run. It will not run if the change occurs in any other range. So set your parameters for the trigger range in this statement. I enclosed the call statement in an If Then statement so that if the change in column H caused an error the code TwoColours code would not run. If you want it to run although column H errors, then remove the 'If Err.Number' statement and its 'End If' . But it will still require the parameters to be set to the range you want th change event to trigger the code on.

The change you made will cause the TwoColours code to run any time a change is made to the sheet.
This is what you want to work with to get it to operate correctly.

Please Login or Register  to view this content.

[shermanwar]

Thank you so much! That did it! Sorry for my delay, but life got in the way of efforts in Excel. Thank you for sharing your time and knowledge. It is Greatly appreciated!!!!!!!

[JLGWhiz]

You're welccome,
regards, JLG