How to create a macro that goes through every item of a dropdown list
Hello
I have a price list with different discount rates (5 pieces) with a dropdown field.
I want a macro that goes through this dropdown list and changes the discount name and the date in the footer of the price list.
how can i put those lines in a for or while loop with the dropdown cell calles "Rabatt"
'C2 = date for example: 2023-08
' Changing date and Pricelistname in footer
i hope it is understandable, thank you in advance.
Please Login or Register to view this content.
Last edited by AliGW; 08-25-2023 at 06:48 AM. Reason: Code tags added - please review the forum rules.
Welcome to the forum.
Please review the forum rules, especially the rule about code tags. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Maybe:ArtikPlease Login or Register to view this content.
To answer the specific question about how to cycle through the options in a dropdown list:
Please Login or Register to view this content.
Last edited by AliGW; 08-28-2023 at 09:15 AM. Reason: Please do NOT quote unnecessarily! Use the QUICK REPLY button instead.
MatrixMan.
--------------------------------------
If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.
Thank you for your answers. I have rewritten the code but I still have problems with the line according to excel
any ideas why?Please Login or Register to view this content.
What error message are you getting? That line runs fine for me so it's something in your file structure; can't tell without seeing the file.
The code as written won't execute because you missed the "r" from dropDownCell in the first line after For i = etc. Also saveLocation is not defined (string) and Type:=x1TypePDF should be Type:=xlTypePDF (you have the number 1 instead of the letter L in lower case).
In the immediate window before executing that line, what is dropDownCell.Address and dropDownCell.Validation.Formula1?
I'm getting runtime error 1004
and the row:dropDownValues = Split(dropDownCell.Validation.Formula1, ",") is marked yellow
thanks for the info with the "r", it doesnt't even come that far^^
That with the savelocation works in an other marco i did in the same file, but i will change that too.
you were completly right with the adress problem - i had the wrong cell - its not Rabatt it is D13.
now it runs a little bit further the problem now is, that it sets the dropdownlist to #WERT and because of that the macro stops...
i would love to show you the file but it is a company file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks