View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian Chappel[_2_] Ian Chappel[_2_] is offline
external usenet poster
 
Posts: 8
Default Referring to OLEObjects (combobox's on worksheet)

How can I refer to, for instance, ComboBox9 to ComboBox20?

I've tried the following but OLEObjects doesn't seem to work , but if I try
to retrieve the object's name, no problem. I have a feeling the OLEObjects
bit is read-only, but I'm not sure how to work round it, without naming each
box.

Dim iX As Integer, sBoxName As String

For iX = 9To 20
sBoxName = "ComboBox" & CStr(iX)
Me.OLEObjects(sBoxName) = ""
Next

The code is located in a Worksheet.