View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ayo Ayo is offline
external usenet poster
 
Posts: 489
Default Object property/method problem

I almost forgot, thanks for the help.

"JLatham" wrote:

For the purposes of debugging and figuring out where in the line of code the
problem lies, break things up for a while until you isolate it:

Dim anyText As String

If TypeName(ctl) = "TextBox" Then
anyText = Left(ctl.Text,2)
anyText = cmbDrive.Text
End If

You've now broken it down into separate components, run it and see who
breaks first. Also, I presume you've previously defined ctl ?

"Ayo" wrote:

Can anyone tell me what is wrong with this code. I keep getting "Object
doesn't support this property or method" error message and I can't figure out
wish object.

If TypeName(ctl) = "TextBox" And Left(ctl.Text, 2) = cmbDrive.Text Then