Replace Array values through loop

Hello all,

Hope someone can help me out in my problem

Please Login or Register  to view this content.

I have the array defined, i want to loop throught the array and replace the values based on select case "variations"

Hope you can tell me why isn't the value being replaced when condition is meet, it keeps the older value (empty)

Not really sure what you want to do though,

If you want to change the value of each string variables, it would be something like

Please Login or Register  to view this content.

Then you need to re-allocate each variable like

Please Login or Register  to view this content.

where do i put that in my code?

right now i have this:

Primeiracolunasearch , segundacoluna search, terceiracolunasearch are combobox's from a form

Please Login or Register  to view this content.

That will be after the loop.

Or maybe use the Dictionary...

Please Login or Register  to view this content.

Originally Posted by jindon

That will be after the loop.

Or maybe use the Dictionary...

I put what you mention, although it doesn't work, have you tested it?

Please Login or Register  to view this content.

MsgBox PrimeiraColunaOndeProcurar returns empty..

No variable used in the 2nd option.

Please Login or Register  to view this content.

Hello jindon,

Sorry to bother you,...AGAIN

It seems to detech the new number, although next i need to filter for that variable, but

Please Login or Register  to view this content.

What do i put in the field?

Hope you can help me out

Solved the question, returning the dic values to the variables to filter

PrimeiraColunaOndeProcurar = dic("PrimeiraColunaOndeProcurar")
SegundaColunaOndeProcurar = dic("SegundaColunaOndeProcurar")
TerceiraColunaOndeProcurar = dic("TerceiraColunaOndeProcurar")

Thanks for your help

Thanks for this topic

Glad you found the way.