Solved: Text box

[zennon]

Hi,

I have a workbook that formats data from a workbook and creates a txt file for upload to an AS/400 via FTP. I need to bring up text entry box where the user can enter their e-mail address, then when the text file has been complied and sent to the AS/400 the user will receive a message to either say the transfer was successfull or not.

I have done everything else but I'm having problems with the text enty box for the e-mail address.

:dunno

[Jacob Hilderbrand]

If you just need to email address you can use an inputbox.

Dim Email As String
Email = InputBox("What is your email", "Email Address Specification")

[zennon]

Great, I was having a bad day, should have got this one myself.

Thanks