Hey Guys,
Just a general question. I'm writing a code right now that runs through a list of markets on a separate excel sheet. There may be a scenario in the future when a new market will be added, but the code in its current form will not be able to handle this market, as I haven't written specific code for each market. I'm using cases to identify each market, my question is that in the case form when I use case else, and say that if there's no market display a message box. Is there a way for me to make this message box something the user can interact with by entering the name of the new market, then based on this have vba simply copy code that I've already written and make it active within the subroutine?
Thanks,
Kam
Just a general question. I'm writing a code right now that runs through a list of markets on a separate excel sheet. There may be a scenario in the future when a new market will be added, but the code in its current form will not be able to handle this market, as I haven't written specific code for each market. I'm using cases to identify each market, my question is that in the case form when I use case else, and say that if there's no market display a message box. Is there a way for me to make this message box something the user can interact with by entering the name of the new market, then based on this have vba simply copy code that I've already written and make it active within the subroutine?
Thanks,
Kam
