21, Feb, 2019
autocad vba draw circle

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

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) […]

VB.NET

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 […]

Excel VBA

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 […]