I have a form with a list of OLE objects imported from Excel (they might as well be images or labels, doesn't matter.)
Form_Current() is set up so when a check box is ticket (one for each object) they are visible or invisible
If PropCD820 = vbChecked Then
PriceCD820.Visi ble = False
Else
PriceCD820.Visi ble = True
End If
Simple enough.. the PROBLEM is to rearrange the visible ones to be one after the other (to avoid white space on the form.)
Any suggestions? Like how to anchor them together when visible?
I'm sure there's more than one way to do this, but any help is much appreciated.
Form_Current() is set up so when a check box is ticket (one for each object) they are visible or invisible
If PropCD820 = vbChecked Then
PriceCD820.Visi ble = False
Else
PriceCD820.Visi ble = True
End If
Simple enough.. the PROBLEM is to rearrange the visible ones to be one after the other (to avoid white space on the form.)
Any suggestions? Like how to anchor them together when visible?
I'm sure there's more than one way to do this, but any help is much appreciated.
Comment