I have been watching your videos to brush up my knowledge on macros...i appreciate your efforts in recording video however I would request you to please explain the pre written codes in more details for better understanding. Thank you and looking forward to learning from you.
Thank you for your feedback. While I try my best to explain everything, it is possible that I may have missed something. Is there any specific part of the code that you did not understand? If yes, then feel free to email me on support@tameexcel.com. Or you can also join the facebook page and post your question there. The link to the FB page is in the description above.
Are you trying to use ".AddItem" to add a new item? If yes, then you will get a “Runtime Error 70 - Permission Denied” if you use it with ".RowSource". You cannot use both together. I would recommend posting your query with the exact code in the FB group and I can help you with the exact solution. The FB link is : facebook.com/groups/msexcelvba
@@SiddharthRout it has been declared. Hence, the next button is working fine. However, when I try to click on the previous button, it gives the mentioned error.
@@TheGamingAI You need to declare the variable at module level. I have a feeling that you have declared the variable at procedure level and hence it is not accesible at the 2nd procedure level. If you wish you can post your code at the facebook page and I can look at the code there. The link to the FB page is mentioned in the decription above. Do not worry, we will get this sorted :)
I have been watching your videos to brush up my knowledge on macros...i appreciate your efforts in recording video however I would request you to please explain the pre written codes in more details for better understanding. Thank you and looking forward to learning from you.
Thank you for your feedback. While I try my best to explain everything, it is possible that I may have missed something. Is there any specific part of the code that you did not understand? If yes, then feel free to email me on support@tameexcel.com. Or you can also join the facebook page and post your question there. The link to the FB page is in the description above.
Very well explained. Subscribed! Thanks
Thank you! Very good video.
ListBox1.RowSource = rng.Address(External: = True)
When I use this code,
Run-time error '70': Permission denied
is displayed. How can I solve this?
Are you trying to use ".AddItem" to add a new item? If yes, then you will get a “Runtime Error 70 - Permission Denied” if you use it with ".RowSource". You cannot use both together. I would recommend posting your query with the exact code in the FB group and I can help you with the exact solution. The FB link is : facebook.com/groups/msexcelvba
You are the best
I have only faced an issue with the previous button:
Compile error: variable not defined
Highlighting “currentRow” after ws
That is becuase you have not declared the variable "currentrow". See the video at 4:57. That variable has been declared right at the top. :)
@@SiddharthRout it has been declared. Hence, the next button is working fine. However, when I try to click on the previous button, it gives the mentioned error.
@@TheGamingAI You need to declare the variable at module level. I have a feeling that you have declared the variable at procedure level and hence it is not accesible at the 2nd procedure level. If you wish you can post your code at the facebook page and I can look at the code there. The link to the FB page is mentioned in the decription above. Do not worry, we will get this sorted :)
@@SiddharthRout could you please elaborate
@@TheGamingAI Like I mentioned, post your code in facebook.com/groups/msexcelvba and we will take it form there.