Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XL2000 - OLEObjects

Status
Not open for further replies.
AllyCat

AllyCat

Programmer
Jul 28, 2003
2
AU
I need to count all the combo boxes on a worksheet (OLEObjects) and then go to the last one to manipulate its properties. I need to repeat this process each time a new combo box is added to the worksheet.

I was thinking about an array or creating a collection, but I just can't get it working!
 
Status
Not open for further replies.

Similar threads

dixiematic
  • Locked
  • Question
OleObjects. Add fails
Replies
0
Views
51
dixiematic
dixiematic
dixiematic
  • Locked
  • Question
deleting OLEObjects in a loop removes only odd numbered objects 2
Replies
13
Views
87
SkipVought
S
locutis
  • Locked
  • Question
XL2000: Show/Hide Columns Problem
Replies
4
Views
35
SkipVought
S
locutis
  • Locked
  • Question
XL2000: Refresh Data for Active Sheet Only
Replies
3
Views
37
SkipVought
S
locutis
  • Locked
  • Question
XL2000: Check Macro for Missing Cell Value
Replies
7
Views
29
locutis
locutis

Part and Inventory Search

Sponsor

Back
Top