All Questions
81
questions
0
votes
3
answers
554
views
Macro to link checkboxes cell at Lib Calc
Context:
I'm trying to learn excel, for personal and profissional purposes. As I can't afford excel at the moment I'm using Lib Calc which I found very similar. I learnt many things that can be easily ...
2
votes
1
answer
647
views
VB6 does not terminate Excel process
I'm having an VB6 application that opens an excel macro enabled file using workbooks.open method. Inside this file, there is an userform that gonna be automatically opened when the file is opened. The ...
0
votes
1
answer
44
views
Fill textbox with selected items in filemanager
I would like to write a program in VBA.
I would like a window to pop up when the program starts, where I can bring up the file manager with a button and the elements what are (multiple)selected here, ...
2
votes
0
answers
113
views
How to solve this triangle problem in Visual Basic? I don't know if I'm doing it right
Make a program that reads a positive integer no greater than 10, and prints a triangle of numbers as follows:
If the number read were 5, then it should print:
1
22
333
4444
55555
The program must ...
1
vote
0
answers
50
views
Insert table from excel to a particular page and paragraph on excel using VBA
How do I paste a table on excel to a particular paragraph on a particular page in MS Word using VBA code?
-3
votes
1
answer
78
views
Transpose based on variable length of items in rows , for a sheet of more than 1000 entries
im very new to vba coding and trying to learn. I have a sheet of more than 1000 entries .
Column A is Sr number, Column B has Names and Column C to Column V has items (20 columns max).
Each name in ...
2
votes
1
answer
392
views
lg Function in Visual Basic
this is an very odd question.
I have a client, which needs an updated version of his program. He gave me all the old files, told me it was an Visual Basic Program, from 1995.
As I am born in 2002, I ...
1
vote
1
answer
402
views
Libreoffice Unable to fill ListBox because I could not declare the listbox righteously
I have a Listbox in my Calc Worksheet and I am trying to address it for filling it with data
DialogLibraries.LoadLibrary("Standard")
oDialog = CreateUnoDialog(DialogLibraries....
1
vote
1
answer
276
views
Libreoffice How to convert Cell.CellAddress.Row (is a number already) to an interger?
I would like to create a String for a CellRange and for that I have a RowNumber, but struggle to append it to a String
The 1st two lines of code are only for clarification, that you know which ...
0
votes
0
answers
26
views
Creating a VBA SUMX2MY2 Function Equivalent
I am attempting to practice my VBA skills by coding the equivalent of SUMX2MY2 in my own function, mySUMX2MY2 (I realize I could use =SUMPRODUCT but I'm practicing functions). I'm trying to do it by ...
1
vote
1
answer
373
views
How to use a module in libre office basic?
I'm used to VBA, but I am supposed to debug some libre office basic code, so I tried to write a basic module in the code-behind to address my worksheet.
The thing is, that whenever I try to run the ...
0
votes
1
answer
83
views
Why does this Union Range in VBA select unwanted cells in Excel?
I'm trying to make my life a bit easier and fill in some values in some cells by using a macro that is activated by a button, the macro looks like this:
Sub Fill_123()
Dim unionRange As Range
Dim ws ...
0
votes
0
answers
106
views
How do I get XRange in LibreOffice calc from OnContentChanged event?
I need to get an object of type ooo.vba.excel.XRange on the OnContentChanged event in LibreOffice calc (7.1) for use in the Application.Intersect function. I've gone through IDL definition files / ...
0
votes
1
answer
338
views
How do I convert this line of VBA into LibreOffice Basic?
How do I convert the VBA
With Worksheets("Sheet1")
.Range("A1:A10").Copy
.Range("D1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=...
1
vote
1
answer
2k
views
Basic VBA to divide two columns
I'm new to VBA and new to StackOverflow and just trying to follow tutorials to get the hang of things.
If I have two columns of numbers, column A and B, I want to divide A/B and put the result into C. ...