Hi
Now when i click on the button Knop1 on the worksheet1 i see in the message the value 0.
What i want is that when i click on the button that i see the year in the message that came from the dropdownbox on the tab extra vergoeding.
Now i have to active first the dropdown and when i click then on the button Knop 1
how can i do that without first clicking on the dropdown
When you address the Ribbon you need the routines to address the ribbon.
Take a look here and see if you can make it work for you.
https://stackoverflow.com/questions/...-combo-box-etc
I would have to go into the UI Custom Editor to check the ID you gave the dropdown etc etc, but since you wrote this you'll probable be able to figure it out
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Try changing the DDjaar_getItemLabel procedure to:Artik
Please Login or Register to view this content.
@Artik: Nice oneworks here
How could I always see the current month or 2 months before in a dropdown list with the names of the months
You configure it like you did the years or you adda another dropdwon form the Months
how do i to that like i did for the years
Needs fine tuning but you can build on from here
@Keebellah
In the dropdown i want to see all the names of the month of the of the entire year.
so i can control more than to moths befor the actual month
It took me a while to find the error in Keeballah's latest code. I found in the MMmaand_OnAction procedure.
"My" proposal after corrections.
Artik
thx for the help
Using Art's file just corrected so that when you click the month you get the month's name in Dutch in case your language setting is not set to Dutch
thx
But how can i make when im programming the ribbon.
Im not always to save and close and reopen the file
You don’t have to program them, they’re dynamic you just select the year and the month and you do whatever you need to do with the results, since it always shows the 12 months you will only have to add a check in your own VBA code that you do not select a month later than the current month when the selected year is the same as the current year
thx
Now ath the end of oktober thy will pay may additional fee of August
Do i want to select 2 months before current month
So i think i hade a sollution for to do that.
I must test it later.
Then i post the code
Let us know if it works. This you can code yourself that when the selected year is the current year and the date is lets say in the the last week you automatically include the previous month or soemthing like that.
Without knowing exactly what you are doing it's just a guess
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks