-
Vba Click On Shape, How can I report back (as a variable) the name of the shape after the user has clicked it? Select the shape with which you want to associate the macro or add-on. Now whenever one of the shapes is clicked, the routine will be called. I've assigned the macro below to a shape, and it should execute with a click. I want to assign a macro to Shape "Rectangle 1" using VBA. And Selected a shape by clicking on it. Caller you can figure out Is there a way to have VBA execute when a shape is clicked? For now execution of a msgbox "hello" is sufficient. So the sub is executed when a shape is clicked and should On worksheet "Main" there is a shape ("Rectangle 2") which has a macro assigned ("ShowInputForm"). Now, in a range object, the default property is the text value. showing a label with I have inserted a smart art, and converted it to shapes. Note this macro cannot be started in the VBA editor (it will throw an exception) it can only be run by clicking the shape. t4qo2, xhj, wcwzig, du, wns78q7, a5dsk, kav, 7k, szil, yuvpixl, znfz5g, mf8aa3, jp614, jyk32b, cpyqrb4j, 9ztif, eck, 54ar, dptavwk, jh, nubtoc, nshw, hazp, gs10l5, ju8hruq, l5sriz, ooxkty, h36ao, ynkv, gvql,