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!
-
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
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!- AllyCat
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
XL2000 Combo boxes and LinkedCell
I haven't programmed in Excel for a while and I have a task set for me. I have a macro which inserts a new row, copying only the formats, formulas and objects from the previous row. All is fine, except the combo box which it copies has a linked cell and when it is copied to the new row the...- AllyCat
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
