Show userform based on cell value

[ipbr21054]

Currently not at my pc but I would like a userform to only be shown if a specific cell is empty.


Would this be correct ?

Please advise.

[COLOR=#000000][FONT=UICTFontTextStyleBody]If Cell (“B1”) = “” Then[/FONT][/COLOR]
[COLOR=#000000][FONT=UICTFontTextStyleBody]Userform1.Show[/FONT][/COLOR]
[COLOR=#000000][FONT=UICTFontTextStyleBody]Else[/FONT][/COLOR]
[COLOR=#000000][FONT=UICTFontTextStyleBody]Exit sub [/FONT][/COLOR]

 

[ipbr21054]

I think it should be,

[COLOR=#000000][FONT=UICTFontTextStyleBody]Private Sub Worksheet_Activate()
If Range("B1") = "" Then
Userform1.show[/FONT][/COLOR][COLOR=#000000][FONT=UICTFontTextStyleBody]Else[/FONT][/COLOR]
[COLOR=#000000][FONT=UICTFontTextStyleBody]Exit Sub[/FONT][/COLOR]