Copy/replace Text Box from sheet to sheet. RRS feed

  • Question

  • This is what VBA need to do

    I have a sheet "Pizza", that is designed for print, that I use after I changed things (calculated ingredients etc.). In the "Text Box 1" is always a manual how to cook it or what to do next.

    I need a macro/vba code that puts a manual "Text Box 1" from sheet "Recipe" to the sheet "Pizza" (printing page, overview).

    - It should copy the text characteristics like color etc. too.
    - I need the "Text Box 1" always on the same place, like a inside the "Text Box 1" copy (but I can make the Text Boxes the same size, so a Text Box replacement on the same place can also do the trick).

    • Edited by Bifi85 Wednesday, January 10, 2018 6:53 AM
    Tuesday, January 9, 2018 7:42 PM

All replies

  • Hi,

    Please explain more detals about what you want to do.



    Wednesday, January 10, 2018 5:19 AM
  • I did a edit top, for more information.
    Wednesday, January 10, 2018 6:54 AM
  • Hi,

    I'm afraid your explanation is not enough for others to make a sample.
    Guessing your wants, I made a sample and shared it via OneDrive. Please download and run it.

    I hope you will specify your needs more clearly.


    I am afraid you need to think about your scenario with most care.
    For example, think if using a TextBox on a worksheet would be good, if using a TextBox on a UserForm would be better, and so on.
    • Edited by Ashidacchi Wednesday, January 10, 2018 8:39 AM
    Wednesday, January 10, 2018 8:24 AM
  • Wow I don't understand your post the your program at all.
    Friday, January 12, 2018 8:26 AM