create textbox per click

[lyntan]

hello. im new to excel and im working on a project dashboard using excel 2013.
is there a way to create a textbox in a chart when i click a userform button? one textbox per click.
and im unable to use activeXcontrols in my excels. it says " cannot insert object"

please help

 

[Simmo1313]

Click on the cell

go to data validation

then input message

 

[Takae]

Like this?

Private Sub CommandButton1_Click()
ActiveSheet.Shapes.AddLabel(msoTextOrientationHorizontal, [B]100[/B], 65, 65, 65).Select
End Sub

I hope you already have a userform and some command-button.

If you will click consecutively, it is better to change the "100".
And I recommend property of the userform is ShowModal / False.

 

[lyntan]

Click on the cell

go to data validation

then input message

oh i need a button click!

 

[lyntan]

sorry i dont have a userform. when i click the button it will go to modules.

 

[lyntan]

oh it worked! thank you!
i have another question. is there a way to add grand total in pivot chart?