Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-11-2022, 02:34 PM
radioMic radioMic is offline Macro to insert shape Windows 10 Macro to insert shape Office 2021
Novice
Macro to insert shape
 
Join Date: Mar 2022
Posts: 7
radioMic is on a distinguished road
Default Macro to insert shape

I have played with VBA in Excel and, got alit okay with it but knowing what I don’t know, I know that I need to ask for help.

I have skulked around the interwebs and found how to insert a shape in the current document -
ActiveDocument.Shapes.AddShape msoFreeForm Left, Top, 300, 30
What I would like to ask is how to adjust the code to insert the shape at the current cursor location within the document? Thinking that would eliminate the Left, Top coordinates ( ! yay ).

Now for the fun stuff... how do I change the fill and line colors of the shape?

And here's the tricky stuff... how do I add a 2x1 table inside of the shape just inserted, adjust the width of and vertically center align ( text for ) the first cell.

Probably one of the more odd asks, but want to say thanks in advance for the help.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to insert shape Word 2016 how to insert a text shape into a word doc ? zillah Word 2 11-14-2019 03:27 AM
Add a macro to a shape guest_gast Word VBA 12 07-07-2018 02:20 AM
Assign Macro to Shape in Word 2013 tunes10590 Word VBA 8 01-29-2015 06:26 AM
Macro to insert shape Easy means to access/insert frequently used Shape rdy4trvl Drawing and Graphics 5 09-16-2012 08:12 AM
Run Macro & Activate shape ibrahimaa Excel Programming 1 01-21-2012 02:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft