hi
@KitaYama
> "Is there any way to fire a function for an associated label?"
no, there isn't. Therefore, what I do in cases where the label needs events, is to cut it and then paste it with nothing selected, than change it's Name to be logical, then:
CLICK event is SetFocus to control that would be associated -- so it behaves as Access would if it was associated. However, if you don't want the label to automatically change the value, then either pop a MsgBox to ask, do something else, or do nothing (that helps Double-Click to properly fire)
Perhaps use Right-Click to do something else -- to me, that's more reliable than Double-click since you have to accomodate if Click happens because the 2nd click wasn't fast enough. Capture right-click in the MouseUp event
> Run a function with any events of check box or its label without changing checkbox state
perhaps use a small command button instead? Maybe with something like
⏺ as caption?