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

add userform to columns other sheet

29230885a.xlsb


1- add userform  to columns  T  to AH


2- T to AH are columns Keys 


3- after the KEY selction add to the columns section in the user form to be selected with check MARK


as we did here : https://www.experts-exchange.com/questions/29230885/add-userform-to-columns.html




Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

So I assume the keys (the left-hand column in the userform) are the data in columns T to AH, but what are the columns in the right-hand column?

Así que supongo que las claves (la columna de la izquierda en el formulario de usuario) son los datos de las columnas T a AH, pero ¿cuáles son las columnas de la columna de la derecha?
ADRIANA P

ASKER
All those that appear in the ORDFORM (BF1  BG1)  columns section plus T to AH
that were the last created and I do not have them in any way to analyze them
Martin Liss

So are you saying that you just want to add those columns to the ORDFORM button?
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
So are you saying that you just want to add those columns to the ORDFORM button?

No

I am saying that the list of columns is contained in the ORDFORM and that this list of columns is the one I need.
on the right side of the new userform for the key columns T to AH and that you also have to add the columns T and AH to ORDFORM
please ! is the last thing to do with 4N (not to return)
Martin Liss

So you want a new button and you want ORDFORM modified. Is that true?
ADRIANA P

ASKER
Yes!!
  a search button as we did in CONSE sheet

I mention ORDFORM button  as sample

but I understand that adding columns to ORDFORM would be reflected in all the other user forms of sheet1 and that's the idea
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

...adding columns to ORDFORM would be reflected in all the other user forms of sheet1
That's not true.
Martin Liss

When you say "Yes" that makes me think you want me to add a new button and modify the ORDFORM button, but when you say "I mention ORDFORM button  as sample", that makes me think that you don't want ORDFORM modified, so please clearly tell me what you want done.
ADRIANA P

ASKER
what I mean is that I would be interested in adding the columns T to AH to all the user forms in sheet1
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Martin Liss

In this workbook I added a nw button in AH1 on Sheet1. I haven't yet added more columns to ORDFORM etc.

Be cautious because if you select 0 in column AF (and probably some other numbers in that or other columns) there will be 188 hits and it will take a long time to run.
29231070.xlsb
ADRIANA P

ASKER
Got it 0

it is a magnificent job
ASKER CERTIFIED SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
2DF

3DF

PAIR FORM

PAIRS SETS

RANGE LOOKUP

TRI FORM  

WK TRI SETS

2 WKS FORM

2WKS PAIR SET FORM

2WKS PAIR-FULL FORM

2  WKS TRI FORM

2WKS TRI SET FORM

2WKS TRI-FULL FORM

MID TOP  

TRI TOPF

PAIR TOPF

TOP FORM

MID PAIR

DD-1

DD-2







⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

I assume that you didn't actually check to see if all of those buttons have missing columns X to AH. I checked a couple (PAIR FORM and TRI FORM) and found that they aren't missing. FYI, on Sheet1 all of the buttons at the following locations use the same form as ORDFORM.
"AR2"
"AT2"
"BP1:BQ1"
"BP2:BQ2"
"BX2:CA2"
"CB1"
"CE2:CH2"
"CJ2:CL2"
"CN1"
"CO2:CQ2"
 "CS1"
"CT1"
"CU2:CW2"
"CY1"
"CZ1"
"DF2:DG2"
"DL2:DN2"
"DT2:DU2"
"EA2:EB2"
"EQ2:ER2"
"ET2:EW2"
"FH2:FI2"
"GN2:GO2"
"GP2:GQ2"
Please inform me if you see any cases where X to AH are missing.
ADRIANA P

ASKER
It's true!!
  appears on all buttons

Great Job !! Best Expert !!
Martin Liss

While working on your new question I found a small bug here.
29231070b.xlsb
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
Great Job !

Martin Liss

Corrected bug in T toAH button.
29231070b.xlsb
ADRIANA P

ASKER
Marvellous you Did ....Best Expert !
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.