Hi All,

I have created a user form and populated it from a list my Workshee
sheetselection change code calls on the userform to pop up the dialo
box and the selection is made from a drop down list my only problem i
this at the moment, when selection is made from the dropdown list
want the userform/dialog box to close.....i do not want to add a cance
or ok button making the use of the box a 2 click operation.

Here's my code so far!

Simon

Private Sub UserForm_Click()
On Error Resume Next
ActiveCell.Select
ActiveCell.Value = ComboBox1.Value
If ActiveCell.Value = True Then

Unload Me
End If
End Su

--
Message posted from http://www.ExcelForum.com