Change Event Handler

[sighlent1]

Hey,

I'm working on this project right now and I'm at a point where I need help with VBA

What I'm hoping to do is, by using the Change Event Handler, I'm looking to change the "Hour Type" from "P" to "I" (or "I" to "P") and have it's corresponding Default Values change accordingly. Please see the attachment for a better description of what I'm looking for

Thank you SOOOO much, I really appreciate your time and efforts,
Bob

[DonkeyOte]

Perhaps along the lines of:

Please Login or Register  to view this content.

above takes into consideration the fact that more than one cell can be updated simultaneously (and need not all reside within your defined named ranges)

[sighlent1]

Thank you SOOOO much DonkeyOte

That's EXACTLY what I am looking for!!!

[sighlent1]

Ohhh, I'm sorry

My Default Values are going to be variable

Is there a way to have the Array be the specific cells as opposed to values?

[DonkeyOte]

It would of course be better to use contiguous ranges for the default values but based on the example:

Please Login or Register  to view this content.

[sighlent1]

Awesome, This is PERFECT......Thank you!!!!!!