how to add code programmatically to a macro for a button
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").Co deModule 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 |
All times are GMT +1. The time now is 03:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com