create an onclick event for a button created by vba

[mdpepper1]

Ive created a form using vba and I have used the createControl function to add a button to the form.

I want to include code in the button creation which specifies what I would like to happen when the button is pressed (run an sql insert )

How can I achieve this?

button code:

     Set ctlNew = CreateControl(frm.Name, acCommandButton, , , "newButton", 500, 500)
    ' Set control's caption.
    ctlNew.Caption = "New Command Button"
    
    With ctlNew
    .Name = "niceNewButton"


    End With

 

[boblarson]

Create a function which will do what you want it to do and then the code would be:

.OnClick = FunctionNameHere()