I have the following code. Problem is that sometimes Cell C1 is Null. When the Cell is Empty, I want to Disable the command Button and change the Caption to nothing to Resume. How can I do this?
Code:Private Sub UserForm_Initialize() Dim strCap As String strCap = Sheets("Output").Range("C1").Value & " Statement Resumed." CmdRes.Caption = strCap End Sub




Reply With Quote