OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Star Basic Macro

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
luigi
General User
General User


Joined: 09 Jan 2007
Posts: 11

PostPosted: Tue Jan 09, 2007 7:34 am    Post subject: Star Basic Macro Reply with quote

Hi! Help please! Can somebody write a macro so that I can do what I do in Excel.

In Excel, when I press ENTER in column D, G and K, the cursor goes to the next ROW DOWN in colums A.

Example, if I return in D7, then the active cell becomes: A8;

if I return in K15, then the active cell becomes: A16.

I have tryed to convert the Microsoft Visual Basics to OpenOffice BUT I CAN NOT GET IT TO WORK.

As I am truly lost, could I please also be told where to copy the macro, PLEASE!

THANK YOU VERY MUCH, Luigi from Australia
_________________
Luigi
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Tue Jan 09, 2007 7:04 pm    Post subject: Reply with quote

Howdy. You do not need a macro for that.

Either use the arrow keys instead of ENTER or use Tools >Customise : Keyboard.

That dialogue opens with the function you want : category "Internal", Function "Move down". In the top box, select "Return" and press "Modify".
_________________
search forum by month
Back to top
View user's profile Send private message
luigi
General User
General User


Joined: 09 Jan 2007
Posts: 11

PostPosted: Thu Jan 11, 2007 4:57 pm    Post subject: Reply with quote

Thank you very much for your guidance, I will have a go and let you know.

Ciao,

Luigi
_________________
Luigi
Back to top
View user's profile Send private message
luigi
General User
General User


Joined: 09 Jan 2007
Posts: 11

PostPosted: Mon Jan 15, 2007 3:38 am    Post subject: PLEASE Help MACRO NEEDED Reply with quote

After much experimentation in solving my original issue, RIGHT ON TOP, ABOVE, the suggestion of going to:

TOOLS>OPTION>KEYBOARD>CATEGORY>NAVIGATTE>TO THE LEFT MARGIN>ENTER>MODIFY>OK

partially works in the sence that if I WOULD BE IN SAY "M 16", BY PRESSING "ENTER", CALC WILL GO TO "M 1"and only if THERE IS NO DATA;

with DATA ENTERED SAY IN CELL "W 23" YOU NEED TO PRESS "ENTER" FEW TIMES BEFORE IT WOULD GO TO "W 1"

BACK TO SQARE 1, CAN SOMEBODY PLEASE - PLEASE WRITE A MACRO, TO SOLVE MY PROBLEM, ABOVE, OTHERWISE, I WILL HAVE TO CONTINUE TO USE MICROSOFT.

THANK YOU IN ADVANCE!

Ciao,

Luigi
_________________
Luigi
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group