Author Topic: Fill selected shapes property value with a VBA form text value  (Read 771 times)

0 Members and 1 Guest are viewing this topic.

Gustavo

  • Jr. Member
  • **
  • Posts: 45
  • The ultimate inspiration is the deadline.
Fill selected shapes property value with a VBA form text value
« on: November 17, 2017, 06:15:16 PM »
Hi all

I'm trying to make a macro that fill some selected shapes property cells value, with the value of a VBA form text field. All instances of the same master shape. For that I've tried to modify a little bit code from this post from VisioGuy http://visguy.com/vgforum/index.php?topic=57.msg183#msg183 in a class module, but how do I call it from a VBA form? Please point me in the right direction.

Best regards.


Yacine

  • Hero Member
  • *****
  • Posts: 2698
Re: Fill selected shapes property value with a VBA form text value
« Reply #1 on: November 18, 2017, 12:59:14 PM »
A usual trigger would be the push of a button.
Create one and in its click event call the desired sub.

sub myButton_Click(...?)
  myRoutine
end sub
Yacine