assign string to phone ie strPhone
strPhone = Application.WorksheetFunction.VLookup(etc)
textbox.text = strPhone
you could probably skip the assign but for learning its easier to understand imo
also if you have to use phone anywhere else you have option to use it
Bookmarks