i have the following code
Private Sub CommandButton1_Click()
Comment1 = "Your Details are as Follows, If you Entered in the wrong number please click clear and try again."
Your_ID_Label = Comment1 & .VLookup(ID_Textbox, Customer_IDs, 2, True)
thanx
Ryan