Tag Archives: Column

No Thumbnail

Excel VBA, Column Gradient Color

In the article Excel VBA, Gradient’s Colors I’ve explained the basics about working with gradient’s color. I’m assuming the reader is familiar with the topics covered in that article. – Gradient Color, Column: In the article Excel VBA, Gradient’s Colors I provided 2 examples for creating gradients with different colors. The examples

No Thumbnail

Excel VBA, Column Fill Color

The following line changes the fill color of the first column to blue: Columns(1).Interior.Color = vbBlue Same as the previous line but instead of using the blue color constant it uses the blue color code Columns(1).Interior.Color = 16711680 For more information about working with colors in

No Thumbnail

Tekla Structures, Create Ties For Part of Column or Beam

Previously in the article Tekla Structures, Create Rectangular Tie Reinforcement I’ve explained how you can fill a column or beam with ties from one end to the other. In this article I will explain how you can create ties for only a part of the column or

No Thumbnail

Insert Concrete Column Using VB.Net (Tekla Open Api)

This article explains how to insert a concrete column in a tekla model using open api in VB.Net – Step 1: Add reference to the Tekla.Structures.Model.dll and the Tekla Structures.dll assemblies and manually start the application. This has been previous explained in the article below: VB.Net Open

No Thumbnail

Excel VBA, Text File to Columns

In this article I will explain how you can read the values in a text file and print them in columns in Excel. For example lets say we have the following data in a text file: We want to read the data from the text

No Thumbnail

Excel VBA, Apply Fill Pattern to Column

Jump To: Apply Fill Pattern to Column Modify Column’s Fill Pattern Color – Apply Fill Pattern to Column: The following line of code applies the Reverse Diagonal Stripe fill pattern to column B: Columns(2).Interior.Pattern = xlDown Note: The intellisense may not work while working with the Columns