use

Me.Close

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Simon Lloyd " wrote in message
...
Hi All,

I have created a user form and populated it from a list my Worksheet
sheetselection change code calls on the userform to pop up the dialog
box and the selection is made from a drop down list my only problem is
this at the moment, when selection is made from the dropdown list i
want the userform/dialog box to close.....i do not want to add a cancel
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 Sub


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