Hello everyone-
What I'm trying to do is basically make is so that when someone clicks the button to continue in my application, it checks to see if a certain text box on the excel page is blank. If it text box is blank, I just want it to place the cursor inside of the box. Here's a small section of my code:
The code above doesn't work. It gives me this error:
"Run-time error '1004': Select method of OLEObject class failed"
So can anyone help me just place the cursor into the text box? Should be easy but I can't get it...
Thanks
-Mark
What I'm trying to do is basically make is so that when someone clicks the button to continue in my application, it checks to see if a certain text box on the excel page is blank. If it text box is blank, I just want it to place the cursor inside of the box. Here's a small section of my code:
Code:
If Len(Sheets("Type1").TextBox3.Value) > 0 Then
Sheets("Type1").TextBox3.Select
End If
The code above doesn't work. It gives me this error:
"Run-time error '1004': Select method of OLEObject class failed"
So can anyone help me just place the cursor into the text box? Should be easy but I can't get it...
Thanks
-Mark