Hi all,
I have been building an Excel Spreadsheet with a number of user forms, everything was working fine - until now.
I will explain:
I have a Main Form (frmMain) which opens a series of other forms.
Every time I click on a command button which opens say the Search Form (frmSearch) it goes into debug mode and highlights the code:
If I click on the Play button, away it goes as normal until I attempt to complete an action on the Search Form and then it debugs and highlights the same code as above?
I am racking my brain, and as this spreadsheet has taken a fair bit of work, I don't want to abandon it now.
Can any one help....please.
I have been building an Excel Spreadsheet with a number of user forms, everything was working fine - until now.
I will explain:
I have a Main Form (frmMain) which opens a series of other forms.
Every time I click on a command button which opens say the Search Form (frmSearch) it goes into debug mode and highlights the code:
Code:
frmSearch.Show
I am racking my brain, and as this spreadsheet has taken a fair bit of work, I don't want to abandon it now.
Can any one help....please.