View Full Version : Solved: Text box

01-22-2008, 07:18 AM

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.


Jacob Hilderbrand
01-30-2008, 04:05 PM
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")

01-31-2008, 02:06 AM
Great, I was having a bad day, should have got this one myself.