Reset Macro Button Code in combination with a Loop

[tnuis]

Hello,

Can anybody help me With what Iīm doing wrong here in this Macro?

In case itīs not obvious what I want to accomplish is that EACH time I click the Rest Button I want the last Cell (Starting from top and then Down) that does NOT have the value "Choose Item Here:" to change into value "Choose Item Here:". Or simply resetting the last cell for EACH click on the button.


Below is the code in question and here follows a Sample Workbook: Sample Workbook.xlsm

Please Login or Register  to view this content.

[AB33]

I do not what are you trying to do, but "Here" is not the same as "here"

"Choose Item Here:"

[watersev]

hi tnuis, option:

Please Login or Register  to view this content.

[tnuis]

This worked watersev. See what you did here. Thank you so much

AB33: I see the mistake there, but even so after correcting it my code does not work, watersevīs code makes more sens, hence it also Works.


Thanks for you time guys!!