Hello,
I am a newbie to VBA and I would really appreciate your help.
I have 120 text boxes with the two letter abbreviations (each unique). They are allocated on the picture of the map. User can input those in the range ("RA2:S23"). I would like to hide all text boxes not meeting the match with the range RA2:S23 (mix of blanks with cell containing two-letter postcodes, they can repeat). Would you be able to help?
Range (example)
LU BV
PT LU
Text boxes (example)
LU PT BZ BV
NN BB CC GH
KL BT VB MM
The names of the text boxes are text box 1, text box 2 ... until text box 120.
Thank you.
I am a newbie to VBA and I would really appreciate your help.
I have 120 text boxes with the two letter abbreviations (each unique). They are allocated on the picture of the map. User can input those in the range ("RA2:S23"). I would like to hide all text boxes not meeting the match with the range RA2:S23 (mix of blanks with cell containing two-letter postcodes, they can repeat). Would you be able to help?
Range (example)
LU BV
PT LU
Text boxes (example)
LU PT BZ BV
NN BB CC GH
KL BT VB MM
The names of the text boxes are text box 1, text box 2 ... until text box 120.
Thank you.
Last edited: