vba tag

72 questions

1 answers
441 views
0

We are investigating the porting of VBA from ACAD to IJCAD, but how do you configure it when IJCAD VBA calls blocks from other drawings?

================================ Check if there is a block copy from other drawings =========================='Regarding the setting in AUTOCAD (2020) below, how should I set it in the case of IJCAD (...

vba

2 years ago

1 answers
405 views
0

Information on extracting data with matrix replacement on a separate sheet

I would like to create a macro VBA that extracts the finished sheet (see photo 2) from the original data sheet (see photo 1).The procedure can be translated into Japanese (see photo 3), but I don't kn...

vba excel

2 years ago

1 answers
342 views
0

Understanding How to Write Loop Processing for VBA

I'm working on an annual cash flow chart in my VBA.When I press the update button, I want the loop processing to input the value every month.Also, I have already created an expression for entering a v...

vba

2 years ago

1 answers
111 views
0

IJCAD version upgrade prevents Gcad.Application objects from being retrieved

The program that works with IJCAD in VBA is by updating IJCAD (2018→2019)Runtime Error 91 Object Variable with Block Variable is now displayed.The VBA reference setting has been modified to 2019 in Gc...

vba ijcad

2 years ago

1 answers
98 views
0

Understanding the Month Function in a VBA

I am writing to inform you of an event that seems to be a bug regarding the month function.When I ran the following vba code without any description in the A1 cell on December 16, 2019, and A2 cell, i...

vba

2 years ago

1 answers
90 views
0

Range Object SpecialCells

To select cells in the lower right corner of the range to understand how to handle combined cells Dim RangeObj as RangeSet Range= ActiveSheet.Range (A4:A7)RangeObj.Cells.SpecialCells (xlCellTypeLastCe...

vba

2 years ago

1 answers
151 views
0

Running Excel VBA from C# and processing time when running VBA directly from Excel

I'm thinking of running Excel VBA on C#.Currently, it takes an hour to run a VBA with a button click from Excel, but the C# side uses Microsoft.Office.Interop.Excel to xlApp.Run(Sheet1.Btn_Calc_Click;...

c# vba excel

2 years ago

1 answers
141 views
0

set the time scale of excel's data analysis graph from zero

I read the csv file and use data analysis to create a graph. I would like to change the scale of the x-axis from date/time to minute and start from 0 just like the y-axis. The formatting of the axis d...

vba excel

2 years ago

1 answers
91 views
0

Can the formula in vba be considered empty?

Does anyone know how to determine that cells (2,2) and cells (2,3) refer to empty characters?Substate() Cells(1,1)=3: Cells(1,2).FormulaR1C1==RC[-1]+5 Cells(2,1)=: Cells(2,2).FormulaR1C1==RC[-1]+6: Ce...

vba

2 years ago

1 answers
128 views
0

VBA Excel Databaseization

Excel has data organized by date in the first column and ID in the first column.I would like to organize this so that it can be used as a database, but please let me know if there is a VBA code that c...

database excel vba

2 years ago

- 2 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656