Thursday, April 18, 2013

EXCEL : VBA programing in excel 2007

Click developer tab.
Add a Command Button from ActiveX controls to the worksheet.
Add the following code by double clicking on command button.

Dim x As Integer
x = 100
Range("A1").Value = x

No comments:

Post a Comment