Adding Text to Shapes or Comments using VBA or Marcos

Поделиться
HTML-код
  • Опубликовано: 26 дек 2024

Комментарии •

  • @markarvin7725
    @markarvin7725 5 лет назад +1

    This is just what I spent half the day looking for and it works perfectly!! Can't thank you enough. 👍

    • @EverydayVBAExcelTraining
      @EverydayVBAExcelTraining  5 лет назад

      Glad it helped. Best of luck in your VBA journey.
      I like to see where the people i helped are from add a pin to my map if you have time
      everydayvba.com/vba-army

  • @arielzabatecuizon5147
    @arielzabatecuizon5147 4 года назад +1

    Is there a word or code ActiveShape? For instance using a vbcode, i want to write something on the selected shape without seeing its name on the namebox. like in a similar manner ActiveCell.value = "Hello".
    I want to write some text on the selected shape or activeshape which its name is not known to me (using vb code). Please help.

    • @EverydayVBAExcelTraining
      @EverydayVBAExcelTraining  4 года назад

      Yes to add text to a shape is a bit of a pain. docs.microsoft.com/en-us/office/vba/api/excel.textframe.characters

  • @abdellahabuhjajabdellah
    @abdellahabuhjajabdellah 3 года назад +1

    Hello brother, nice explanation and thanks for the translation You touched on an important topic for me, with a question, please

    • @abdellahabuhjajabdellah
      @abdellahabuhjajabdellah 3 года назад

      My request is that the note fetch a cell statement from another page

    • @EverydayVBAExcelTraining
      @EverydayVBAExcelTraining  3 года назад +1

      I am not totally following. You want to grab a comment from a sheet and move it to another sheet

  • @joshinanikkithas5101
    @joshinanikkithas5101 2 года назад

    Iyy