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

add navigation list

4N BP to add DATE LIST NAVIGATION
29217266a_add_NavLIST.xlsb

1-add  an navigation lis by YEAR in sheet1  B2 DATE for all years and new years will be added as is
2- as  shows: (not Keys just the WEEK section)
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

Okay it looks like you want me to copy the date and ORD values from Sheet1 snd break them up by years, I don't understand what you want to do with the userform.

De acuerdo, parece que quiere que copie la fecha y los valores ODD de Sheet1 y los divida por años, no entiendo qué quiere hacer con el formulario de usuario.
ADRIANA P

ASKER
Okay it looks like you want me to copy the date and ORD values from Sheet1 snd break them up by years, I don't understand what you want to do with the userform 

Yes !! but can be in a new question ?



in this question
need an way to move around the Sheet1 dates fast

with an userform like you did i can do it

so i want create an button to open an userform with the list of  dates so i can move more faster as needed

so in the next question i will need  break them up by years in sheet BYYEARS  as you see already




Martin Liss

so i want create an button to open an userform with the list of  dates so i can move more faster as needed
Are you saying that you want a button added to Sheet1 that is like the one in the picture but without the keys?

¿Está diciendo que desea agregar un botón a Sheet1 que sea como el de la imagen pero sin las teclas?

BTW:)
2021-06-07_08-03-01.png
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
Are you saying that you want a button added to Sheet1 that is like the one in the picture but without the keys? 

yes Sir.


to navigate through column B (dates)
and so move quickly to the dates I need
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
As needed

Great JOb !!
 Best Expert !

ADRIANA P

ASKER
You DID !!
i did't see at first

as needed !
Thanks for the Great Job !
⚡ 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

Are the keys correct?
ADRIANA P

ASKER
yes ! working as needed !
ADRIANA P

ASKER
how I have my difficulties to express myself
I was anxious trying to explain it and trying to make you understand me so I was suffering for not knowing how to explain it
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ADRIANA P

ASKER
but you  get it !! that the most important