I was trying to run this code in VBA and it doesn't work. I got an error saying "Object doesn't support this property or method" (it stops in very first line of For Each statement. I tried to do it in Visual Basic and it worked. Do you have any ideas why it doesn't work in VBA?
Here is the code:
Thanks, and happy Thanksgiving!!!Code:Private Sub txtFirstWestOne_Change() Dim stText As String stText = txtFirstWestOne.Text For Each Control In Me If TypeOf Control Is TextBox Then If Control.Text = stText Then MsgBox "Something" End If End If Next End Sub
------------------
Visual Basic Programmer (at least I want to be one)
------------------
PolComSoft
You will hear a lot about it.
[This message has been edited by QWERTY (edited 11-25-1999).]




Reply With Quote