how to add code programmatically to a macro for a button

T

Tina

hi,
i have coded the following lines, but i am not sure of how to insert
code within the macro Button_click. Also I am not sure of what
"Module1" is.
can someone help me please?
TIA!
Tina
============================================================
For i = 0 To 4
ActiveSheet.Buttons.Add(50 + i * 100, 10, 80, 25).Select
Selection.OnAction = "Button_click"
Selection.Characters.Text = "Play Game" & i

Dim VBCodeMod As CodeModule
Dim LineNum As Long

Set VBCodeMod =
ThisWorkbook.VBProject.VBComponents_("Module1").CodeModule

With VBCodeMod
LineNum = .CountOfLines + 1

*** what do i write here to display a messagebox?
*** i want to add code to the Button_click macro.

End With
ActiveSheet.Range("A1").Select
Next i
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top