Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro code behind button | Excel Worksheet Functions | |||
Add a Button Programatically plus code | Excel Discussion (Misc queries) | |||
VBA code for search button | Excel Worksheet Functions | |||
configure add button & code | Excel Discussion (Misc queries) | |||
code to reassign a macro to a toolbar button because of path change | Excel Discussion (Misc queries) |