Search code examples
vbadata-masking

for loop in function using vba to do data masking

how do I replace the data that I want to mask without hard coding the * but replace the * with the number of letters that required masking?

I am new to VBA so i am using the C# and java logic to complete this. However the for loop in VBA is rather confusing to me

Solution

  • If you want to generate a string of repeated characters, use the String function

    String(6, "*") will return ******