View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
bg18461[_3_] bg18461[_3_] is offline
external usenet poster
 
Posts: 1
Default How to enter a Range of TextBoxes?

Ok, I got rid of error 9 (subscript out of range) - wrong sheet name
however this error has been surplanted by 'Run-time error 438' - Objec
doesn't support this property or method.

Here is my code:

Dim i As Long
For i = 16 To 31
Worksheets("INSRD VEH PASS").OLEObjects("OptionButton" & i).BackColor
&HFFFF&
Next i

It appears to not like the OLEObjects method, but I cannot figure out
way around this. Any suggestions..

--
Message posted from http://www.ExcelForum.com