Solve : VBA Excel need to add what column to look at to this macro?

1.	Solve : VBA Excel need to add what column to look at to this macro?
Answer» HI, I have a working MACRO that targets all of the ComboBoxes in my worksheet. I need it to only target whatever Column I choose. The Column will be the location of the comboBoxe's. Here's what I have that works but does every COMBOBOX on my SHEET. Code: [Select] Sub AllocateLinkedCellsToComobBoxes() Dim cbo As OLEObject For Each cbo In ActiveSheet.OLEObjects If TypeOf cbo.Object Is ComboBox Then cbo.Select Selection.LinkedCell = Selection.TopLeftCell.Address cbo.LinkedCell = cbo.TopLeftCell.Address End If Next End Sub

Discussion