Hello All
here the situation. I am using MSForms2.0 frame object with additional controls embedded in the frame object (by the right-click, frame object=> Edit method)
The reason for this setup:
-I don't want to use a userform as this is the form itself (don't want superimposed form over excel)
-Embedding the additional controls directly into the worksheet means I can't do control tip text, where I put in instructions that appear on mouse-over)
So I've built my lil form using a frame control and embedded additional controls into it, have my instructions that appear on mouseover.
Problem is, how do I write a trigger event for a embedded control?
The view code is disabled and I've tried such like
Private Sub Frame1_Checkbox1_Click()
Sheet1.Frame1.Object.Checkbox1.caption = "aawwww yea"
end sub
thing is, this doesn't work. If I use it for an object embedded in the worksheet, it works fine,
Private Sub Optionbox1_Click()
Sheet1.Frame1.Object.Checkbox1.caption = "aawwww yea"
end sub
but not for objects embedded in the frame.
Any pointers?
Bookmarks