UserForm Assistance.

[tobyhutton1234]

Hi all,

When someone clicks on a certain cell a userForm appears and they enter some details, click ok and then the info in put into that cell.

But once the info is in the cell the userForm still appears. How can I stop the userForm from showing when there already info within that cell.

Thanks

 

[JamesW]

Hi,

Try adding this to the top of your worksheet sub (assuming you have something similar to below):

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Target.Value <> "" Then Exit Sub
    ....

 

[VoG]

You would need something like

If Range("A1").Value = "" Then userform1.Show

 

[TiaXL]

userform1.hide