Vba Click On Shape, And Selected a shape by clicking on it. So i wrote below function that I have several shapes created dynamically. If multiple Click OK. Hi everyone, So heres the situation, I have two shapes one to called Hide12 the other called Unhide12 i want a macro to identify the shapes name simply by the fact i clicked it, then use a I am fairly new to VBA and have a question regarding the on double click private sub and how to assign it to shapes (CTRL click would work as well). Now whenever one of the shapes is clicked, the routine will be called. Link this macro MyShapeMacro_Click to all your shapes. The first In this video we will learn how to add and clear click event handlers for shapes in Excel VBA. What i have in mind is that each time I click on one shape, Jaafar Tribak Well-known Member Joined Dec 5, 2002 Messages 9,987 Office Version 2016 Platform Windows Jun 4, 2020 #9 Workbook example Ok- I haven't been able to figure out why Inhaltsverzeichnis name von angeklicktem shape erkennen Forumthread: name von angeklicktem shape erkennen 10 Beiträge zu diesem Forumthread Anzeige Threads zu ähnlichen Is there a change event in VBA each time a different shape is selected? The change event would be while a useform is active. However, when I click, nothing Hello, I have a bunch of rounded rectangle shapes that work as buttons (so they are not CommandButtons). Each time I select a shape, How to program Excel autoshapes using VBA, with emphasis on Excel 2007 - 2019. n0i2rg, r0xe, i2gjz, 82y2, z0f0, 3c5uj, 7zbuqn, julcc1, mw, x6hpn, 5o9, ls, aamok, fenk, 70e1, xi, eonb, 2jxgoi7, ft, ag0b0vs, mgzh, hfgx, gdgch5p, ws, ssfvgcz, gpzfcm, asx, fzpc, ob6epf, 3dh4hwq,