satisfy condition to run user form

[VBAmalta89]

I have a user form in which the user needs to input data in a number of text boxes. This user form is run from a button on an excel worksheet.

I need to create a condition so that this user form cannot be opened unless there is a value in a particular cell in a particular worksheet, i.e when the button to open the user form is clicked a message is prompted that the user form cannot be run. This is because the cell in worksheet 2 cell B12 is blank.

Is it possible to do this?

 

[VoG]

Try like this

If Sheets("Sheet2").Range("B12").Value = "" Then
    MsgBox "Sheet2!B12 must be completed", vbInformation
    Exit Sub
End If

 

[VBAmalta89]

ok ill try but wer do i place this code?

 

[VoG]

Inside your button code, before the userform is displayed.

 

[VBAmalta89]

ok i managed i placed it in the module wer the button is run from.

THANKS!