htger.blogg.se - Visual basic for excel starter

Before you can enter the code that will refresh the chart, you need to know the name of our chart.

Enter the following code between the Private Sub and End Sub lines:.

To do this, select Tools ► References, then scroll down and select SAS Add-In 4.3 for Microsoft Office. The editor should contain some code to get you started.īefore you type in any code, you must add a reference to SAS Add-In for Microsoft Office 4.3.

You should see a code editor that has CommandButton1 and Click by default at the top. Double-click on the button to bring up the Visual Basic editor.When you are done, close the Properties window. Right click on the button and select Properties, then customize the value for Caption so that the button reads Push to Refresh (or whatever text you'd like). To create the refresh button, click the Developer tab and select Insert, then Command Button.Ĭlicking this option turns your pointer into a cross and enables you to draw the outline of a button wherever you want it in your Excel sheet.

This sample uses Microsoft Excel data and the SAS graph created in Sample 40977. In this sample, you will learn how to create a button that will refresh your SAS content. You can use the power of Visual Basic to customize and automate functionality in the SAS Add-In for Microsoft Office.