Hello all,

I am trying to have a text box display address information depending on what store is selected from a combo box. Said combo box is pulling information from a different worksheet. I am familiar with the VBA language to an extent. Basically, I'm trying to embed a vlookup function in the text box which automatically updates the information depending on what store is selected from the combo box (i.e. exactly how cells automatically change display information once the information in the target cell for the vlookup is changed.)

Any help would be great. Thank you!