Events on shapes
One more question:
In a workbook, I want to create a visual representation (blockdiagram) of data in an input sheet. I currently do this by creating shapes on a sheet. The problem is now that I want to have events when these shapes are clicked/double clicked. I have been looking like crazy, but can't find a way to get it done. Is it possible? I thought about showing the graphs on a form rather than on a sheet, but can't find any controls which allow me to display them as elements of a blockdiagram (labels, arrows & rectcanlges) Any advice is welcome Christof |
Events on shapes
Have you tried Right-Click on the shape and assign Macro?
APJ "Christof De Backere" wrote in message ... One more question: In a workbook, I want to create a visual representation (blockdiagram) of data in an input sheet. I currently do this by creating shapes on a sheet. The problem is now that I want to have events when these shapes are clicked/double clicked. I have been looking like crazy, but can't find a way to get it done. Is it possible? I thought about showing the graphs on a form rather than on a sheet, but can't find any controls which allow me to display them as elements of a blockdiagram (labels, arrows & rectcanlges) Any advice is welcome Christof |
All times are GMT +1. The time now is 11:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com