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

add user form to column CQ on 4nf plus update RNUM form

4n to add user form CW column 

29226317.xlsb


1- add button in CU2 to CW2   call it  "2WKS TRI FORM"


2- column  CW  is the KEY for the userform


3-Can the form in  Button RNUM in BP1 BQ1 be update  as the others users form to select list .


i means that this form be  the same as the others that allows me to select columns

(like the  one will be use here)

Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon
Martin Liss

1- add button in CU2 to CW2   call it  "2WKS TRI FORM"

2- column  CW  is the KEY for the userform
Please give me a list of all button ranges, button names, and keys that you want to add.
ADRIANA P

ASKER
1- add button in CU2 to CW2   call it  "2WKS TRI FORM"
1- column  CW  is the KEY for the userform

2-add button in DT2 to DU2   call it  "PAIR TOPF"
2- column  DT  is the KEY for the userform


3-add button in EQ  TO ER2   call it  "MID PAIRF"
3- column  EQ  is the KEY for the userform


4-add button in FH2  to FI2   call it  "MID TOPF"
4- column  FH  is the KEY for the userform


5-add button in CB2    call it  "PAIRS SETFORM"
5- column  CB  is the KEY for the userform

6-add button in CN2    call it  "TRI  SETFORM"
6- column  CN   is the KEY for the userform


7-add button in CS2    call it  "2WKS PAIR SET FORM"
7- column  CS   is the KEY for the userform


8-add button in CY2    call it  "2WKS TRI SET FORM"
8- column  CY  is the KEY for the userform

9-add button in DL2  TO  DN2  call it  "TRI TOPF"
9- column  DL is the KEY for the userform

10-add button in GN2  TO  GC2  call it  "DD-1A"
10- column  GN is the KEY for the userform

11-add button in GP2  TO  GQ2  call it  "DD-2B"
11- column  GP is the KEY for the userform

12-  UPDATE THIS USERFORM -add button in BF1  TO  BQ12  call it  "RNUM"
12-UPDATE - column  BQ is the KEY for the userform


13-add button in CZ2    call it  "2wks TRI-FULL FORM"
13- column CZ is the KEY for the userform


14-add button in CT2    call it  "2wks PAIR-FULL FORM"
14- column CT is the KEY for the userform




Martin Liss

5-add button in CB2    call it  "PAIRS SETFORM"
5- column  CB  is the KEY for the userform
The PAIRS SETS button does exactly the same thing.
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
ok I think I am sometimes confused with the situation of the button that creates the numbers horizontally for PAIRS and TRI
Martin Liss

So are you saying that you don't need the CB2 button?
ADRIANA P

ASKER
Please !! If it is already done, do not do it twice
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

'6-add button in CN2    call it  "TRI  SETFORM"
'6- column  CN   is the KEY for the userform
That's the same as WK TRI SETS so it's not needed.
Martin Liss

'7-add button in CS2    call it  "2WKS PAIR SET FORM"
'7- column  CS   is the KEY for the userform
I'm going to put that in CS1 since there's nothing there now.
ADRIANA P

ASKER
Very well!! Thanks for identifying them
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
Accepted the recommendation
Martin Liss

'12-  UPDATE THIS USERFORM -add button in BF1  TO  BQ12  call it  "RNUM"
'12-UPDATE - column  BQ is the KEY for the userform
I don't understand that. We already have an RNUM button in BP1 to BQ1 where the source is BP.
ADRIANA P

ASKER
the way that opens with RNUM button is one where I can't select other columns to parse and compare

as the user forms  from what we are putting in the last buttons
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

Actually in a version of the workbook that you haven't seen yet I already changed RNUM to use the userform, but you say you want the button to be in "BF1  TO  BQ12" and that can't be correct, so please tell me where the button should be.

En realidad, en una versión del libro de trabajo que aún no ha visto, ya cambié RNUM para usar el formulario de usuario, pero usted dice que desea que el botón esté en "BF1 TO BQ12" y eso no puede ser correcto, así que dígame donde debería estar el botón.
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
everything is fine thanks for RNUM I need it like this and the location of the button

I identify a small error (do not indicate it like that but I need to)

I need to add this
 
1- add button in BP2 to BQ2 call it "REPEAT 4N"
1- column BP is the KEY for the userform
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.