Opensource Hardware and Software Tutorials
AutoCAD VBA Sample code to draw circle with Center, Radius and Colour as variables — CODE BEGINS —- Function drawcircle(ByVal x1c As Double, ByVal y1c As Double, ByVal r1c As Double, ByVal cc As Integer) Dim Centerpoint(0 To 2) As Double Dim CirObj As AcadCircle ‘Start Coordinates Coordinates XYZ Centerpoint(0) […]
AutoCAD VBA Sample code to draw circle with Center, Radius and Colour as variables — CODE BEGINS —- Function drawcircle(ByVal x1c As Double, ByVal y1c As Double, ByVal r1c As Double, ByVal cc As Integer) Dim Centerpoint(0 To 2) As Double Dim CirObj As AcadCircle ‘Start Coordinates Coordinates XYZ Centerpoint(0) […]
Write to excel file – Simple example Dim APP As New Excel.Application Dim worksheet As Excel.Worksheet Dim workbook As Excel.Workbook workbook = APP.Workbooks.Open(“D:\excelfile.xlsx”) worksheet = workbook.Worksheets(“Sheet1”) Dim iter1 As Integer For iter1 = 1 To 50 ‘Add data to cells of the first […]
You can insert buttons inside an excel document to perform certain predefined functions to make your work easier. The functions can be formulas, formatting, printing certain cells or range etc. Before you insert a button, you have to write its function inside the VBA editor (modules), we will use an […]