View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default For, Each, If, Loop?

effectively, yes.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rick_Stanich"
wrote in message
news:Rick_Stanich.241vj4_1141316107.0136@excelforu m-nospam.com...

There is no Conditional Formatting?

Ignore this question if I am way off track.
Is the following code looking for a textbox on the worksheet? (its how
I read it).

For Each obj In Worksheets("sheet2").OLEObjects
If TypeOf obj.Object Is MSForms.TextBox Then


--
Rick_Stanich

I am me
------------------------------------------------------------------------
Rick_Stanich's Profile:

http://www.excelforum.com/member.php...o&userid=28957
View this thread: http://www.excelforum.com/showthread...hreadid=517920