Thank you so much! I'm glad you enjoyed the video on creating a quiz app in Excel using VBA. I believe this tutorial will be helpful for many Excel VBA users who want to build interactive applications. If you have any questions or need more tutorials like this, feel free to ask. I’ll keep creating more Excel VBA content in English for the community. Thanks again for your support, and please share it with others who might benefit from learning Excel VBA!
Sid Thank you very very much for this. It's awesome!. I am pleased that my previous comment inspired you to make this application, but I wasn't expecting it, it was a nice surprise however. I have still to finish going through your course one by one so forgive me if my next question has been answered already, but I haven't come across it yet if it has. If I made the sheet with the list of questions hidden, would the code still work? including the random question picker? Many thanks.
Yes you can hide the worksheet and the code will still work. As I mentioned in the video those sheets are for the quiz master to see. You can hide them. And the reason for that is very simple. I am not using .Activate/.Select. I have declared the objects and I am directly working with it. In fact, I have spoken about it here. Maybe my next video can be about this? :D stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba/10718179#10718179
Congratulations, excelente vídeo Sid! Thank you for doing the video in English and I hope it reaches many many users of excel VBA.
Thank you so much! I'm glad you enjoyed the video on creating a quiz app in Excel using VBA. I believe this tutorial will be helpful for many Excel VBA users who want to build interactive applications.
If you have any questions or need more tutorials like this, feel free to ask. I’ll keep creating more Excel VBA content in English for the community. Thanks again for your support, and please share it with others who might benefit from learning Excel VBA!
Sid Thank you very very much for this. It's awesome!.
I am pleased that my previous comment inspired you to make this application, but I wasn't expecting it, it was a nice surprise however.
I have still to finish going through your course one by one so forgive me if my next question has been answered already, but I haven't come across it yet if it has.
If I made the sheet with the list of questions hidden, would the code still work? including the random question picker?
Many thanks.
Yes you can hide the worksheet and the code will still work. As I mentioned in the video those sheets are for the quiz master to see. You can hide them. And the reason for that is very simple. I am not using .Activate/.Select. I have declared the objects and I am directly working with it.
In fact, I have spoken about it here. Maybe my next video can be about this? :D
stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba/10718179#10718179
Can i get the codes for each step
The file can be downloaded using the link mentioned in the description above.