Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag 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)

Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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.
Avatar of 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




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.
ok I think I am sometimes confused with the situation of the button that creates the numbers horizontally for PAIRS and TRI
So are you saying that you don't need the CB2 button?
Please !! If it is already done, do not do it twice
'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.
'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.
Very well!! Thanks for identifying them
Accepted the recommendation
'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.
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
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
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial