Apologies for the delay in responding. Thank you both!
Another potentially related question--we are trying to have rows hide/unhide based on the number of regions being displayed for a selected country. There are multiple countries all with a different number of regions. We would like users to enter data for the country they select and have it only display the appropriate number of rows. I am wondering if a loop would work here to automate things a bit? But am struggling to get the code to work. There are a lot more tables than in the sample here and 54 countries so if there is a way to avoid writing IF statements for each country for each table, I am all ears! Any suggestions? Thank you so much in advance!
As you have a further form under the first form i think you will need VBA simular to last time.
If there was only 1 form or they were side by side, you could get away with conditional formatiing based on the top left cell
