VBA Code to close userform after data selection only

[mattless1]

I have a list of 10 shops as a list box named lstitems i need the user to click one of the 10 shops and when they click the selected shop it tells then thanks and the name they selected. then i require a Quit button that transfers the selected Shop to cell D3 & then closes the userform, but if they do not pick a shop it will ask them to pick one before it closes. so they must select or it will not close.

Do you think this can be done?

Many thanks in advance for any help!

 

[HalfAce]

Who would have thought that Half Aces slapping approach was user friendly?

The only one who gets any real satisfaction out of that is me.