Make a cell active

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
User avatar
AccessShell
Posts: 47
Joined: Tue Apr 05, 2022 2:17 am

Make a cell active

Post by AccessShell »

In LO Calc with VB6

OK, so I know very few if any one else is using VB6 with LO Calc. But, I have seen some code in other languages that I MIGHT be able to translate.

I cannot seem to translate an LO Calc macro, so please don't give me that. For example, I cannot seem to translate expressions like "ThisComponent" to another language. There are probably more, but now I am concentrating on this.

I need to some some code to make a cell active. I am not putting anything into this cell, I just want it to be the activecell.

Thanks
LibreOffice 7.3.3.2 (x64) on Windows 10 Home
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Make a cell active

Post by Villeroy »

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
AccessShell
Posts: 47
Joined: Tue Apr 05, 2022 2:17 am

Re: Make a cell active

Post by AccessShell »

This document is overwhelming. I'll have to study it a while to get my answer.

Thanks Villeroy
LibreOffice 7.3.3.2 (x64) on Windows 10 Home
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Make a cell active

Post by Villeroy »

And while you are in it: [Tutorial] Introduction into object inspection with MRI (also on the LibreOffice web site)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply