Close userform code in VBA

[mattless1]

Can someone help please??

I have a userform, which has a listbox and a transfer data button to a cell inside my workbook.
I want to have a button to close the userform after an item has been selected and transferred, but it must not close the userform until a item has been transferred to the workbook. this is to stop staff bypassing the userform.

Many thanks

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-...de-visual-basic-applications.html#post3572423