Thank you so very much, I really appreciate that. I have new shorts every Saturday (or Friday evening depending upon where you are) Thank you for your Likes, Shares & Comments. It really helps.
Randy, thanks for sharing your knowledge and skills. Would it be possible to have the code for this? I tried to follow the video, but maybe I missed some instructions. Thanks in advance.
Hi and thanks very much. Sure, you can download the workbook with this link: www.dropbox.com/scl/fi/93kdfbw5mj4dw7m8hgial/PopUp_Details.xlsm?rlkey=7w6g50xr0dx4sinx4pnfeszdt&dl=1 (Please make sure to right-click the file, go to properties and unblock macros before opening, if they are blocked) I hope this helps and thanks so much.
great little vba app. one comment is how to set the Target.Range("A4:d14") to look to the last row of data in the worksheet. Tried replacing D14 with LastRow 'Dim LastRow As Long 'LastRow = Cells(Rows.Count, "A").End(xlUp).Row 'If Not Intersect(Target, Range("a2: LastRow")) Is Nothing Then but it did not work
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi and thanks for your comment, shapes cannot be displayed on a userform, however you can use a picture of a shape, and display that picture on the userform. I hope this helps and thanks so much.
Hi and thanks, anytime you run a macro, the undo history will be cleared, however, I have solved that problem with this training ruclips.net/video/6TnxPvLz_44/видео.html I hope this helps and thanks so much.
it's difficult capture all the code as it goes off the screen to the right. I can almost do it a frame by frame on my phone and get it but not on my laptop at all. I understand this is a short but there is no way to slow it down. Is it possible to just post the code
HI Keven, thanks for your message. Yes i know it can be a bit difficult. I have complete training on this here (with free download): ruclips.net/video/yFqJCCEsi_Y/видео.html Also you can download this workbook for the short here: www.dropbox.com/scl/fi/93kdfbw5mj4dw7m8hgial/PopUp_Details.xlsm?rlkey=7w6g50xr0dx4sinx4pnfeszdt&dl=1 I hope this helps and thanks so much.
For sure, you are very welcome. I am happy to help and share; You can find a longer video on something similar here: ruclips.net/video/yFqJCCEsi_Y/видео.html
🤩 Supercharge Your Income: 40% Off Mentorship Program This May 2024 ► bit.ly/MentorProgram_YTComment
Thank you for this #SHORTS it was very helpfull!
For sure, you are very welcome and happy to help and share.
Very Interesting.. nice 👍
Thank you so very much, I really appreciate that
Thanks!
Thank you so very much, I really appreciate that Alexander
That is so clever!
Thank you so very much, I really appreciate that. I have new shorts every Saturday (or Friday evening depending upon where you are)
Thank you for your Likes, Shares & Comments. It really helps.
Very nice bro.
Thank you so very much, I really appreciate that
Randy, thanks for sharing your knowledge and skills.
Would it be possible to have the code for this? I tried to follow the video, but maybe I missed some instructions.
Thanks in advance.
Hi and thanks very much. Sure, you can download the workbook with this link:
www.dropbox.com/scl/fi/93kdfbw5mj4dw7m8hgial/PopUp_Details.xlsm?rlkey=7w6g50xr0dx4sinx4pnfeszdt&dl=1
(Please make sure to right-click the file, go to properties and unblock macros before opening, if they are blocked)
I hope this helps and thanks so much.
@ExcelForFreelancers Thanks so much.
great little vba app. one comment is how to set the Target.Range("A4:d14") to look to the last row of data in the worksheet. Tried replacing D14 with LastRow
'Dim LastRow As Long
'LastRow = Cells(Rows.Count, "A").End(xlUp).Row
'If Not Intersect(Target, Range("a2: LastRow")) Is Nothing Then
but it did not work
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
is it possible to Show shapes like this on a userform as well, like a tutorial information?
Hi and thanks for your comment, shapes cannot be displayed on a userform, however you can use a picture of a shape, and display that picture on the userform.
I hope this helps and thanks so much.
I've tried something similar in the past, but the issue I had was that it would erase the undo history.
Will this do that as well?
Hi and thanks, anytime you run a macro, the undo history will be cleared, however, I have solved that problem with this training
ruclips.net/video/6TnxPvLz_44/видео.html
I hope this helps and thanks so much.
it's difficult capture all the code as it goes off the screen to the right. I can almost do it a frame by frame on my phone and get it but not on my laptop at all. I understand this is a short but there is no way to slow it down. Is it possible to just post the code
HI Keven, thanks for your message. Yes i know it can be a bit difficult. I have complete training on this here (with free download): ruclips.net/video/yFqJCCEsi_Y/видео.html
Also you can download this workbook for the short here:
www.dropbox.com/scl/fi/93kdfbw5mj4dw7m8hgial/PopUp_Details.xlsm?rlkey=7w6g50xr0dx4sinx4pnfeszdt&dl=1
I hope this helps and thanks so much.
Will this still work if you hide the columns?
Yes for sure it will work. VBA can read data in hidden columns. Thank you for your Likes, Shares & Comments. It really helps.
Awesome, I think this will help me make a clean look for item descriptions and their vendors on an inventory project I'm doing
For sure, you are very welcome. I am happy to help and share; You can find a longer video on something similar here: ruclips.net/video/yFqJCCEsi_Y/видео.html