Join Curt Frye for an in-depth discussion in this video Running macros using command buttons, part of Learning Excel Cluster Analysis.
…One of the lesser known features of Excel is that you can attach…a macro to a shape and run the macro whenever you click that shape.…In this movie, I will show you how to create shapes with macros…attached so that you can generate…random centroids and update centroids values easily.…My sample file is the command buttons macro-enabled workbook and you can…find it in the chapter two folder of your exercise files collection.…This workbook contains two macros.…And if I go to the view tab, click the Macros button's down arrow, and click View…Macros you can see that they are named GenCentroids and UpdateCentroids.…
I won't run either of them now.…I'll just go ahead and click Cancel.…So what I want to do, is create…shapes, that when clicked, run either of those macros.…So I'll go to the Insert tab.…Then I'll click the Shapes control.…Your shapes controller button might look different…based on the resolution of your monitor.…And I'll make them rounded rectangles.…So I'll click there, and you see that my…mouse pointer has changed into a black cross hair.…
- What is clustering?
- Setting up your Excel table
- Creating a list of centroids
- Identifying the closest centroid
- Updating centroids using averages
- Automating updates with macros
- Analyzing your data in Excel
- Visualizing data in a chart