Referencing Multiple Cells in Footer

[das09]

I've tried to a create code from examples in previous posts but I can't seem to figure out how to get what it is that I'm looking for.

I'm trying to reference the value in cell O9 which would be a number. Preceding this value, I would like to have the word "Rev" displayed. Just underneath those values, I would like to reference the value in O7 which is a date (3/27/2014 for example). I would like the footer to be updated anytime that cells O9 or O7 are updated.

These values would be placed in the right side of the footer of the active worksheet, and be displayed on each page that is printed out. Any help or suggestions would be appreciated.

It's not much, but here's what I have so far:

Please Login or Register  to view this content.

[adyteo]

use Worksheet_Change when O7 or O9 are changed, run UpdateFooter procedure.

[das09]

Thanks but I have no idea how to do this. I also don't know how to include the Value of O7 so that it shows below the value of O9.