Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

create user-form key and company columns DD to FE 4n

29258672.xlsb  4n



1-create a look-up using a user form  5 distributed buttons IN : DT1 DU1,  EB1 EC1,  
EX EV1,   FF1 FG1,   EP1 EQ1,   ( so i don't have  to scroll so long to work with the button)


2-for keys columns:   DD DG  DI  DJ  DK DL DM DO DP DQ  DS DV DW DX  DY  EA  ED EE  EF  EG  EH  EI EJ  EK  EL  EM   EN   EO ER  ES  ET  EU  EV  EW   EZ  FA  FB  FC  FD  FE



3-in the columns Sections of the user-form :  columns: I J K L M N  P Q R S U V

X Y Z  AA AB AC  AD AE  AF  AG  AH  AI  AK AL AM AN AO AP AR AS AT AU AV AW BU BW BY CA CD CE CF CG CH CI CJ CK CM CN  CO CP CQ CR CS CT CU 

DD DG  DI  DJ  DK DL DM DO DP DQ  DS DV DW DX  DY  EA  ED EE  EF  EG  EH  EI EJ  EK  EL  EM   EN   EO ER  ES  ET  EU  EV  EW   EZ  FA  FB  FC  FD  FE




as we did here for 4BROW but now for this file :https://www.experts-exchange.com/questions/29240017/Create-Look-UP-for-4R.html






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

1-create a look-up using a user form  5 distributed buttons IN : DT1 DU1,  EB1 EC1, EX EV1,   FF1 FG1,   EP1 EQ1

I assume you mean EX1 EY1, but before you answer that let me suggest that we add just one new button called "Lookup DD to FE" in CY:DC that would require one of the DYNAMIC buttons between DD and FE to be selected. Or we could go even further and call the new button "Lookup Dynamic" which would work for all the DYNAMIC buttons on the 4N sheet.

Supongo que te refieres a EX1 EY1, pero antes de responder eso, permíteme sugerir que agreguemos solo un nuevo botón llamado "Lookup DD to FE" en CY: DC que requeriría uno de los botones DYNAMIC entre DD y FE para ser seleccionado. O podríamos ir aún más lejos y llamar al nuevo botón "Lookup Dynamic" que funcionaría para todos los botones DYNAMIC en la hoja 4N.
I went ahead and added the new "Lookup Dynamic" near CY:DC, so you can now create sets for any existing (or new) DYNAMIC column. Like the other four buttons that create sets, you need to select the source column or a cell in the source column before clicking the "Lookup..." button. In this case however you should avoid clicking the "DYNAMIC..." button in row 1.

Seguí adelante y agregué la nueva "búsqueda dinámica" cerca de CY:DC, por lo que ahora puede crear conjuntos para cualquier columna DINÁMICA existente (o nueva). Al igual que los otros cuatro botones que crean conjuntos, debe seleccionar la columna de origen o una celda en la columna de origen antes de hacer clic en el botón "Buscar...". En este caso, sin embargo, debe evitar hacer clic en el botón "DINÁMICO..." en la fila 1.
29258691.xlsb
Avatar of ADRIANA P

ASKER

the problem I have is that the button is very far from the columns that are far from it

  that is to say, if I am working with a column I need to be close to it to see the values and when I am so far away it does not let me see


once it opens the sub form it does not move and it does not let me move to the columns that I am covering example as shown in the photo


a41.PNG

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

Great JOB


Best Expert