If ActiveCell has a comment then exit sub
Do you have the latest version with the label above the textbox?
Yes, the Label that informs to use CTRL + Enter for new line?
I do have a couple questions...
The Private Sub cmdOK_Click() code has:
UserForm1.txtCom.Enabled = False
And Private Sub cmdCancel_Click() code has:
.Enabled = False
But neither button Click dismiss the UserForm from the sheet.
I have to use the Red X cancel to close the UserForm.
I'm unsure how to fix that if indeed it requires fixing.
Howard
|