generate textbox on button click

[lyntan]

hello! please help!
how to generate textbox on button click?
i got this code :
ActiveSheet.Shapes.AddLabel(msoTextOrientationHorizontal, 2800, 900, 100, 30).Select

it works but its a plain box without background colour or border.
i need a coloured textbox on button click in excel.
please help ;(

 

[My Aswer Is This]

Start the Macro recorder and create yourself another textbox color it the way you want and then run the script again.
This is a recorder it records everything you do and the saves the recording. Then when you click macro from the ribbon choose the macro and run it.
Do not create the textbox before stating the recorder. Start recording click on the textbox on the ribbon put the textbox where you want and then format its color and what else you want then stop the recorder.


If it works assign the macro to a button not to the textbox.
Do you know how to assign a macro to a button.

 

[lyntan]

I would suggest running the recorder again. Make a new box and try it again. Try running the script a few times from the macro menu on the ribbon if it works ok try assigning it to a button.

hello. thank you. it works after many attempts and figurations. thanks a lot. ! it really helps me a lot!

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

hello. thank you. it works after many attempts and figurations. thanks a lot. ! it really helps me a lot!

 

[lyntan]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

thank you !
i posted another forum regarding slicers.
http://www.mrexcel.com/forum/excel-questions/890495-choose-data-show-slicer-excel.html
i need help on that too