Making a selection sets other list boxes to default selection?

English
#1

I have multiple forum control list boxes (not data validation list menus). How would I make selecting something from one of them select the default selection from all the other list boxes on the same sheet only?

My old brain refuses to learn how to write macros. :frowning:
The list boxes are in cells:
B5, B7, B9, B11, B13, E22, E24,E26,E28.

#2

Edit your question and attach an example file with data and the desired solution.

#5

I doubt that it is feasible without a macro. The content of a list box is a value while you want it to be as well a formula. This is incompatible. Only a macro will solve your problem.
The example from @koyotak shows how to set up the list of values in a second list box (cell E11) based on the selection in the first list box (cell C11). But it doesn’t not reset anything.

#6

There are no formulas involved.
Edit: Correction. There are formulas involved in conditional formatting the list box selections apply to other cells. Would there be a way to do this with the conditional Formula Is:

$E$22=“this” (then?) $E$24=“that”

?

I’m using form control List Boxes, not data validation list menus. Perhaps I should have specified that. Apologies I didn’t. I edited to include that.

I assume a macro is probably the easiest and cleanest way of doing this. I’m not able to write macros. That’s what I need help with.

A file in a speaking language I don’t read or speak isn’t helpful.
I can’t read it.

#7

Found a way to do it by recording a macro. I recorded changing the linked sell values the list boxes are linked to manually to the default selection. It works, I imagine there’s probably an easier or better way to do it with less code than recording a macro produces?

#3

try this, it’s in deutsch:
1_LibreOffice-CALC_Daten-GĂźLTiGKEiT_2fach selektierte Auswahl_iN ARBEiT_v0002.ods (25.1 KB)

#4

I only speak English. I don’t understand anything it says and there aren’t any list boxes in the file shared.

#8

Solution!

Step 1: Move the listboxes out of the way if they’re hiding their linked cell.

Step 2: Record a macro typing in the default selection to all the linked cells except the linked cell to the one you want the macro changing. Then stop the recording and name the macro module.

Step 3: Enter this macro as the Execute Action in the events tab of the listbox you want this action to be triggered from when it’s changed.

Repeat these steps for the other listboxes.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.