Hi all,

I hope y'all can help me out with this problem. I am working on programming an Excel spreadsheet with the HeaderFooter procedure. This is how the code looks:

'HeaderFooter Procedure
'Procedure to customize the header and footer
'
Sub HeaderFooter()
    'Inserts the filename in the header
    Worksheets("January 2003").PageSetup.CenterHeader = "&F"
    'Declares the variable LeftFooterText as a string
    Dim LeftFooterText As String
    'Prompts user for left footer text
    LeftFooter = InputBox("Enter your full name:")
    'Inserts response into left footer
    Worksheets("January 2003").PageSetup.LeftFooter = LeftFooterText
    Worksheets("January 2003").PageSetup.CenterFooter = ""
    'Inserts the date into right footer
    Worksheets("January 2003").PageSetup.RightFooter = "&D"
End Sub


My problem is that I can't seem to get my name to display on the left-side footer of the spreadsheet in Print Preview. Anybody got a clue as to what could be wrong with the code?

Thanks in advance,


Ben Horne
Madison Area Technical College student
-------------------------
http://community.webshots.com/user/valerian114

Go there. I have a lot of awesome photos that I rendered myself

__________________
Ben Horne
-------------------------
I don\'t want to sound like I haven\'t made any mistakes. I\'m confident I have.

Most likely using FireFox and concocting my next Macromedia Flash project
Snibworks Forums Moderator

Welcome to the New Age

You declared the variable with the name 'LeftFooterText'. Then your input box references "LeftFooter". Change that to "LeftFooterText" and the string should appear.