Code for using a saved class module

Hi,

I am a learner of excel vba. I have created a macro and saved as .cls file at a particular path. I am trying to create a new xlsm file, place a command button in it and use this saved class module on click of the command button created.

I completed my work on creating a xlsm file, placing a command button over there and importing the saved class module. The module sits as "sheet11" under class module in the new xlsm file. How do I use that module's code to execute the macro by clicking the command button?

Regards,
Aravinth

Call it

Call Sheet11.macroname

This is the code I used

Set wb1 = Workbooks.Add
wb1.VBProject.VBComponents.Import "D:\vba\getohlc.cls"
Sheets("sheet1").Select
Set obj = ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", _
Link:=False, DisplayAsIcon:=False, Left:=200, Top:=100, Width:=100, Height:=35)
obj.Name = "TestButton"
'buttonn text
ActiveSheet.OLEObjects(1).Object.Caption = "Test Button"

code = "Private Sub CommandButton1_Click()" & vbCrLf
code = code & "Call Sheet11.commandbutton1" & vbCrLf
code = code & "End Sub"

With ActiveWorkbook.VBProject.VBComponents("Sheet1").CodeModule
.insertlines .countoflines + 1, code

It returns the value inside the quotes (Call sheet11.commandbutton1) rather than pulling the code from sheet11

Regards,
Aravinth

Why do you add the code on the fly, it seems totally pointless. Add it permanently.