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.
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