Dear All,
Once again I need your help. I have a problem with macro in the attached sheet. When I click submit button all the answers from main sheet are going to results sheet and sheets becomes clear except Tech id and name. The macro is working fine if there is at least one answer. But if all the answer are blank it is showing some runtime error which is also normal becaue there is nothing to clear. But I want it should transfer all the answers as 0 if all the cells are blank without showing any error. Is it possible. If yes kindly solve it for me and amend the code in attached file.
Thanks in advance for kind support
Regards.
Hi SEHRA,
Before the line that gives you the error put a line of
and just after the line that gives the error putOn Error Resume Next
See if that helps.On Error GoTo 0
One test is worth a thousand opinions.
Click the * below to say thanks.
Thanks MarvinP.
you people are genius.
Dear marvin,
I want one more help. When i click submit button it should ask me " Do you want to submit your answers" If answers 'yes' it should run macro. if no it should remain in the same sheet.
Kindly help
Hi SEHRA,
You can use an InputBox for the question and then use the answer to Exit Sub or continue on.
See http://www.exceltips.nl/?tag=inputbox
or http://www.ozgrid.com/VBA/inputbox-function.htm
for the method and syntax.
One test is worth a thousand opinions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks