S
Stuart
I cannot find a way to clear the contents of an
ActiveX textbox.
Here is what I would like to say:
Sub ClearTextbox()
Dim oleObj As OLEObject
For Each oleObj In ActiveWorkbook.Sheets _
("Contract Master Order").OLEObjects
If TypeOf oleObj.Object Is MSForms.TextBox Then
If oleObj.Name = "Control 1" Then
With oleObj
'clear the contents
End With
End If
End If
Next
Would appreciate help, please.
Regards.
ActiveX textbox.
Here is what I would like to say:
Sub ClearTextbox()
Dim oleObj As OLEObject
For Each oleObj In ActiveWorkbook.Sheets _
("Contract Master Order").OLEObjects
If TypeOf oleObj.Object Is MSForms.TextBox Then
If oleObj.Name = "Control 1" Then
With oleObj
'clear the contents
End With
End If
End If
Next
Would appreciate help, please.
Regards.