You can use the InputBox function to crate a variable and then use that
variable in the footer. Create the variable:

myVar = InputBox("Enter something", "Enter")

The to put it in the left footer:

Sheets("SheetName").PageSetup.LeftFooter = "&myVar"

"SteveDB1" wrote:

Hi all.
I'm interested in making a macro that will do my "page set up"
configurations for me.
While I already have made one through manual record, and I've modified parts
of it, I'm left with 3 elements that I do not know the coding for, or if it's
even possible.
In my footer, there are 3 panes.
The left pane I hard-wire the date that I actually work the file.
In my center pane, I place the file name-- but not &[file]. Again, I
"hard-wire" the name. While I can hear a few comments stating that it'd be
just as easy to use &[file], we try to avoid that here, as we've had troubles
with it in the past, and not enough of us would pay enough attention to catch
it beforehand.
What we have in the right pane works as is, so that's unimportant as we're
satisfied.
So, my question-- with the footer, can I do an "application.inputbox()" for
the two panes-- left, and center?
If so, how would I go about coding something like this?
I just need to better understand that part, as mentioned, I've already got
the rest of it done, and it works quite well.
Thank you.
Best.