How can I loop through the selection set in a userform controls? i tried this but it didn't work. i know how to loop through all the controls, but not the selection set.
Sub LoopSelectedControls()
If Selection.count < 1 Then Exit Sub
Dim obj As Control
With Selection
For Each obj In .Controls
Debug.Print TypeName(obj)
Next obj
End With
End Sub
so i have learned how to put a command "Nudge Up" on the context menu for userform controls "MSForms Control" and now need to cycle through any selected controls on the userform to nudge in a particular direction (Up/Down/Left/Right). in working with the selection command, that is only for selecting cells (at least that is what i found so far). so is it possible to create a selection set of selected controls on a userform?