Adding Text to Shapes or Comments using VBA or Marcos

  Рет қаралды 6,998

EverydayVBA

EverydayVBA

Күн бұрын

Пікірлер: 8
@markarvin7725
@markarvin7725 5 жыл бұрын
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 3 жыл бұрын
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 3 жыл бұрын
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 жыл бұрын
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 жыл бұрын
I am not totally following. You want to grab a comment from a sheet and move it to another sheet
@joshinanikkithas5101
@joshinanikkithas5101 2 жыл бұрын
Iyy
How To Master Shapes With Excel VBA - For Beginners
52:04
Excel For Freelancers
Рет қаралды 11 М.
VBA - Looping through a Table (ListObject) and deleting a row
8:49
Try Not To Laugh 😅 the Best of BoxtoxTv 👌
00:18
boxtoxtv
Рет қаралды 7 МЛН
这是自救的好办法 #路飞#海贼王
00:43
路飞与唐舞桐
Рет қаралды 102 МЛН
When u fight over the armrest
00:41
Adam W
Рет қаралды 12 МЛН
Excel VBA Introduction Part 52.3 - Adding Text to Shapes
36:27
WiseOwlTutorials
Рет қаралды 19 М.
Extracting Comments from Excel Sheet -  VBA Automation Tips
11:10
The Worst Programming Language Ever - Mark Rendle - NDC Oslo 2021
1:00:41
NDC Conferences
Рет қаралды 1,3 МЛН
The Flaws of Inheritance
10:01
CodeAesthetic
Рет қаралды 963 М.
4 Game-Changing AI Tools You Didn’t Know Existed For Research
12:38
Andy Stapleton
Рет қаралды 4,2 М.
3 Tips for Writing Formulas with VBA Macros in Excel
8:09
Excel Campus - Jon
Рет қаралды 212 М.
Try Not To Laugh 😅 the Best of BoxtoxTv 👌
00:18
boxtoxtv
Рет қаралды 7 МЛН