Visual Basic® 2010 Unleashed

Designing the Add-In

You notice how the IDE embeds a fully functional instance of Microsoft Excel in the designer. This is useful because you can drag and drop Windows Forms controls from the toolbox onto the document’s surface. The goal of the example is to provide controls for filtering a list of orders. So in the first row add the following columns titles: Order ID, Ship Country, and Shipped Date. Next, add the fictitious orders information listed in Table 52.1 according to the column titles.

Table 52.1 Populating Orders Information

Now select the cell range from A2 to C5 and name the range as Orders. The next step is to add a TextBox named ...