Pausing Loop When Switch is Tripped for User Input
Posted on 2011-09-08
I am developing an Excel import script that is importing tables from Excel. During this import process, I am checking the fields data type, format, and size. That I have figured out. But what I am trying to accomplish now is to make sure that the Field names are matching what is expected.
I have a variable for the expected field name checking against the field names within the table properties/tabledefs. If there are no matches then it sets my variable: str_MatchSWX = "FAIL".
What I would like to do is pause the loop when the variable = "FAIL". THen get the user's input. After the user reassigns the field name, the loop can start back up where it left off.
Is there a break that we can program into the VBA?