Відео

My pleasure. Thanks for watching. Wish you a wonderful day.

Hello! Thank you for your comment. However, the voiceover in this short is my own voice. I'm sorry if the 'terrible' refers to this voice. Thank you for watching, and I wish you a wonderful day!

Hello! Thank you very much! Yes, there is. All we need to do is remove the hour component and set the 'for' loop for the minute component to run from i = 0 to 15. I hope this helps! Thanks for watching, and I wish you a wonderful day.

@@ahsing_excel_VBA Thank you!, really appreciate it!

My pleasure. Thanks for watching. Wish you a wonderful day.

Thanks! Thanks for watching. Wish you a wonderful day.

Thanks! Thanks for watching. Wish you a wonderful day.

My pleasure. Thanks for watching. Wish you a wonderful day.

My pleasure. Regarding your issue, I'm not sure if you can try the 'SetFocus' method. Setting focus on any control on the UserForm may help the macro better detect the desired window. I hope this helps. Thanks for watching, and I wish you a wonderful day!

@@ahsing_excel_VBA Thank you, that's an easy fix and great idea. Thank you for your help. May your day be wonderful too.

Shame, I had to drop this macro from my process since I couldn't get it to consistently screenshot the worksheet. I thought SetFocus would work, but it didn't. I added in loops of DoEvents and still had issues. My users were unhappy and I was frustrated putting out fires. Worked well on my Windows 10 PC, but inconsistent on Windows 11.

My pleasure. Thanks for watching. Wish you a wonderful day.

Hello! To display multiple file names while consolidating data, you might consider linking the file names to the caption of a UserForm. This way, the file names will appear in the UserForm’s caption, which is visible while the progress bar is running. Thanks for watching. Have a wonderful day! ❤

@@ahsing_excel_VBA could you please help me to get the tutorial,

Thanks! Thanks for watching. Wish you a wonderful day.

Hello! Thank you for your interest in learning with me. Unfortunately, I’m not currently offering one-on-one courses. However, I appreciate your support and hope you find the videos helpful. Have a great day!"

My pleasure 😊 Thanks for watching. Wish you a wonderful day.

Fantastic!!!!! Is there a way to control and type the cell for multiple cells or must it me one by one? This is a great video! Thank you!

My pleasure. Thanks for watching. Wish you a wonderful day.

Hello. My pleasure. Regarding the issue you're experiencing, could you please clarify whether the file is located on your local computer or on a server? If it's on a server, you might need to enable macros each time you open the file. Additionally, please ensure that the workbook is set to auto-calculate, as the macro relies on this feature. Thanks for reaching out, and I hope you have a wonderful day!

My pleasure. Thanks for watching. Wish you a wonderful day.

Hello! Whether the last row requires contact information or email depends on how the range is defined. If you need those fields to be mandatory, make sure to include them in your range. Otherwise, you can leave them out. Thanks for your comment, and have a wonderful day!

Hello. Recent updates to MS Office prevent users from removing passwords by changing the file format, especially if you are using MS Office 365. You may consider the new method shown here: ua-cam.com/video/z9PeiAz33r0/v-deo.html. I hope it helps you. Thanks for watching, and have a wonderful day!

My pleasure. Thanks for watching. Wish you a wonderful day.

Hi! If you want to apply this trick to all your workbooks, you might find this method helpful: ua-cam.com/video/A8bpF3RhF-U/v-deo.html. I hope you find it useful. Thanks for watching, and have a wonderful day!

You’re most welcome, boss 🤝🤝🤝

My pleasure. Thanks for watching. Wish you a wonderful day.

Thanks! It is my pleasure to share with you. Thanks for watching. Wish you a wonderful day.

Could you please provide your email address so I can send the file to you? If you're concerned about privacy, you can also email me directly at ahsing.math.excel@gmail.com, and I'll respond there.

My pleasure. I'm glad it helps you. Thanks for watching. Wish you a wonderful day.

My pleasure. Thanks for watching and have a nice day.

@@ahsing_excel_VBA what if you wished to fit A B C into the estimated profits how so that we see the area of cover based on the estimated profits

Customization of the code is necessary. This tutorial only demonstrates how to extract a password under the assumption that it contains only two lowercase letters. Additionally, changing the file path is another crucial step. If you were to copy the code verbatim without customization as instructed, the consequences would be as you described. Thanks for watching and have a nice day.

@@ahsing_excel_VBA I did do all the changes for 11 letters and the path. and got the message I give above

Hello, it may be because the file is in the drive where autosave is enabled. You may try disabling it to see if the issue is resolved. Thanks for watching. Wish you a wonderful day.

@@ahsing_excel_VBA Thank you! The problem was elsewhere. I had a line in my code that promped saving at the beggining. :D Anyway, thank you for your fast reply, you are doing a great job! Please continue. :)

My pleasure 😊

Thanks! I'm glad you like it 🙏 Thanks for watching. Wish you a wonderful day.

Thanks! Thanks for watching. Wish you a wonderful day.

can u sand my fille

Hi. You might want to try a different hex editor. Also, it's important to ensure that the folder is created in the right location before changing its file format. Thanks for watching and have a nice day.

🤔 I didn't help anyone remove the password to avoid getting involved in any unauthorized act. Sorry for that.

I'm glad you like it. Thanks for watching. Wish you a wonderful day 😀

Hi. This is an add-in calendar where the default setting sends the selected date to the active cell. You may consider changing the default setting if applicable; otherwise, a customized macro is needed. Thanks for watching. Wish you a wonderful day.

Hi. Select the required region and navigate to the 'Home' tab. Look for 'Conditional Formatting' and then 'Clear Rules,' either only for the selected region or the entire sheet. This will not highlight the cells even if they are selected. Hope this helps. Thanks for watching and have a wonderful day.

Glad it was helpful! Thanks for watching. Wishing you a wonderful day.

Thanks! Thank you for your suggestions. The reason I didn't indent is because it would increase the length of the code and might cause it to extend beyond my recording region. As you may have noticed, I use a larger font size and have enlarged the VBA script editor to enhance readability. Most of the time, I assume my audience has their own customizations, so I use multiple lines for 'If' statements. This allows them to add conditions as needed. Thanks for watching. Wishing you a wonderful day.

@@ahsing_excel_VBA thank you sir

Hello. 🤔 Since this is specifically for the calendar, which allows users to select and insert a date instead of typing it manually, I expect users to select a date before proceeding to the next task. If you want to run multiple macros at the same time, I usually open the workbooks as new instances of Excel so that they can run simultaneously. Not sure if this is what you were looking for. Thanks for watching. Wishing you a wonderful day.

My pleasure. Glad it helped. Thanks for watching. Wishing you a wonderful day.

Thanks! Thanks for watching. Wishing you a wonderful day.

Hi, you can add a line to define the variable first.

I tried to add as Dim WS as Worksheet Is it correct?

@@ahsing_excel_VBA What line i need to add as variable, Can you provide me the line , It will help me

yup. It is correct.

Did you notice a new worksheet was added? If so, delete the new worksheet and run it again. It should be fine then.

Yes every time new worksheet is getting created as blank

Hi. Thanks! If you are using the 'SelectionChange' event, copy the code and paste it into all necessary sheets in the VBA editor. Also, ensure that there is a list box on each spreadsheet. Thanks for watching and have a nice day.

​@@ahsing_excel_VBA thanks for your reply. is there a way just only create one List objects, then apply to other sheets. Instead creating list objects on each sheets. Thanks

Yes, there is. Instead of using controls, you may consider using a UserForm. Then call the UserForm whenever a cell within the desired ranges is selected.

Also you can Create an Add In from that Then it will be available All your workbook or worksheet But you have to knowledge of the Class Modules

Thanks! Thanks for watching. Wishing you a wonderful day.

really is

😅 Maybe one day Excel will introduce a new chart type that allows us to construct filled shape charts directly. Thanks for watching. Wishing you a wonderful day.

Hi. You have to test it one by one, trying two characters and then three, and so on. However, if you used a long and complicated password, it may take days to retrieve it. Therefore, it's very important to provide a pattern to Excel and narrow down the range of possible characters in use. I wish you success in getting back your password as soon as possible. Thanks for watching and wishing you a wonderful day.