[Solved] Identifying information on a client by row colour

Creating a macro - Writing a Script - Using the API

[Solved] Identifying information on a client by row colour

Postby Kalysta » Fri Oct 18, 2019 3:03 pm

Perfect - thank you.

I am a long time user of a different spreadsheet and very new to OO and there are a few routines I am finding it hard to complete.

I have 8 clients. Each client has a button assigned on the spreadsheet.

On button press, I wish to have:
The client's identifier inserted at the selected Cell in Column B; (i.e. A,B,C,D,E,F,G,or H, at $B$5) (Each client may have multiple entries)
The row background colour changed across a limited number of columns. (e.g. $B$5:$R$5)
The cursor move to the next row in column B to await input from of one of the eight buttons. (i.e. repeat the routine)
Ideally I would like to have column B populated in a couple of minutes from the macros assigned to the button presses.

If the cursor or active cell is not in column B and the button pressed I would also like to assign an info box (e.g."inappropriate action")

I have tried recording a macro but I always end up back at the first input cell on a button press.
Last edited by Kalysta on Sun Oct 20, 2019 10:02 am, edited 1 time in total.
Windows 10
Open Office 4.1.7
Kalysta
 
Posts: 4
Joined: Fri Oct 18, 2019 2:03 pm

Re: Identifying information on a client by row colour (Macro

Postby Zizi64 » Fri Oct 18, 2019 3:29 pm

Please upload an .ods type sample file here.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.3.2; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8460
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Identifying information on a client by row colour (Macro

Postby FJCC » Fri Oct 18, 2019 5:07 pm

Are you looking for something like in the attached file? The background color of the cells is set to the same color as the button and the string of the cell in column B is set to be the same as the button label.
Attachments
Buttons.ods
(11.32 KiB) Downloaded 11 times
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7351
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Identifying information on a client by row colour (Macro

Postby Kalysta » Sat Oct 19, 2019 7:27 pm

Hi.
Please be patient - I am having problems viewing emails from this site telling me I have an update and using the link - I just go into a loop with no access to the site. I can get around it.

here is the opening page of the .ods file.

I appreciate your help.
Attachments
Pig_Management.ods
(29.53 KiB) Downloaded 7 times
Windows 10
Open Office 4.1.7
Kalysta
 
Posts: 4
Joined: Fri Oct 18, 2019 2:03 pm


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 5 guests