Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

Select more than one PAIR in 2n column E

VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

Okay here it is. I've changed the userform in this workbook so that it looks like this. If you need the textbox pointed to by the arrow, please help me understand why.

De acuerdo, aquí está. He cambiado la forma de usuario en este libro de trabajo para que se vea así. Si necesita el cuadro de texto señalado por la flecha, ayúdeme a comprender por qué.
2020-02-08_05-55-36.png
ADRIANA P

ASKER
Martin

in some situations moving faster  the textbox  help me a lot
Martin Liss

Okay I'll leave it but I think the new checkboxes are easier to use. Is the rest if the workbook okay?

Está bien, lo dejaré, pero creo que las nuevas casillas de verificación son más fáciles de usar. ¿Es el resto si el libro de trabajo está bien?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ADRIANA P

ASKER
Yes !!


well the relative  button is not working

but  should be chechk in other question
Martin Liss

well the relative  button is not working
Please don't make me have to guess what isn't working; tell me.

Por favor, no me hagas adivinar lo que no funciona; Dime.
ADRIANA P

ASKER
Martin

the realtive button
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

I know you mean the relative button. What I don't know is what you mean when you say it isn't working. All these things could be what you mean when you say it isn't working:
  • When I press the button Excel crashes.
  • When I press the button nothing happens.
  • When I press the button I get the wrong results.

Those are the things that I need to know. When you don't give me enough information I have to guess at what's wrong.

Sé que te refieres al botón relativo. Lo que no sé es a qué te refieres cuando dices que no está funcionando. Todas estas cosas podrían ser lo que quieres decir cuando dices que no funciona:
  • Cuando presiono el botón Excel se bloquea.
  • Cuando presiono el botón no pasa nada.
  • Cuando presiono el botón obtengo los resultados incorrectos.

Esas son las cosas que necesito saber. Cuando no me das suficiente información, tengo que adivinar lo que está mal.
ADRIANA P

ASKER
Martin   the relative button


When I press the button nothing happens.


Cuando presiono el botón no pasa nada
Martin Liss

Okay here is the problem. The workbook that you originally posted was not set up for 2N. What I mean by that is that there should not be 'Left 3' and 'Right 3' sections as shown in the picture. Hopefully you can find a previous 2N workbook that only has one section under the Relative button. If you can find it then attach it here and I'll make the same changes that I made in 29172063.xlsm.

De acuerdo, aquí está el problema. El libro de trabajo que publicó originalmente no se configuró para 2N. Lo que quiero decir con eso es que no debería haber secciones 'Left 3' y 'Right 3' como se muestra en la imagen. Espero que pueda encontrar un libro de trabajo 2N anterior que solo tenga una sección debajo del botón Relativo. Si puede encontrarlo, adjúntelo aquí y haré los mismos cambios que hice en 29172063.xlsm.
2020-02-09_08-52-41.png
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ADRIANA P

ASKER
Martin

can we do the pairs in column E

then closed the question
 
it will take me some times  to find other 2N workbook

rigth now is not the priority for me
Martin Liss

No I don't want to do that because as I said, the workbook that you originally posted was not set up for 2N and if I make more changes to it I'd just have to redo them for a proper 2N workbook.

No, no quiero hacer eso porque, como dije, el libro de trabajo que publicó originalmente no estaba configurado para 2N y si hago más cambios, solo tendría que rehacerlo para un libro de trabajo 2N adecuado.
Martin Liss

I've found a workbook of yours (29152402.xlsm) where we did "relative" for 2N, but in that workbook "relative" looks like the picture below which is very different than the "relative" in the workbook you attached for this question so I don't know what you want to do.

Encontré un libro de trabajo suyo (29152402.xlsm) donde hicimos "relative" para 2N, pero en ese libro de trabajo "relative" se parece a la imagen de abajo, que es muy diferente al "relative" en el libro que adjuntó para esto. pregunta, así que no sé qué quieres hacer.

2020-02-10_05-37-29.png
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
Martin

ok we can use the last one you find will be ok to me
Martin Liss

What would you like me to do in that workbook?
ADRIANA P

ASKER
Martin

can you send me the last book?
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ADRIANA P

ASKER
What would you like me to do in that workbook?

is need do the column E

to find multiple pairs
Martin Liss

Let me show you a trick. (At the end of the video I press Return.)
2020-02-10_07-42-13.mp4
Martin Liss

Why did you choose this post of yours as the solution?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

Also
is need do the column E

to find multiple pairs
Don't you mean column 'A'?

In case you can't get my trick to work, here's the workbook.
29152402.xlsm
ADRIANA P

ASKER
Martin

i was posting an comment

for some reason it select the solution  was not me  or my intention
Martin Liss

I've asked a moderator to undo that selection of the post as a "solution".
Your help has saved me hundreds of hours of internet surfing.
fblack61
ADRIANA P

ASKER
Martin

ok i see you point now

let that as is

please

keep the  working on file 2N_to_find_pair.xlsm
to column E to work with multiple pairs

because it will be other work
ADRIANA P

ASKER
I've asked a moderator to undo that selection of the post as a "solution".

Thnaks !!!
ASKER CERTIFIED SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ADRIANA P

ASKER
I already did that in the 29172063.xlsm file I attached earlier. That workbook has mysteriously disappeared however so I'm attaching it again.

I never see it !! until now

that why i keep asking for  work on it
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
Im trying to give the points ! !
Martin Liss

I never see it !! until now
Okay but what did you mean when you said the relative button isn't working in this post?
ADRIANA P

ASKER
Okay but what did you mean when you said the relative button isn't working in this post?

when i hit the button RELATIVE  it don't show the  data as needed

but i saw this in file 4N and 3N

this 2N file look is working

than i understand your confution
but i will need work that some times foward rigth now need work with  tri in file 4N  
i will open an new question for
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck