![Ah Sing Excel TV](/img/default-banner.jpg)
- 272
- 556 878
Ah Sing Excel TV
United States
เข้าร่วมเมื่อ 18 มี.ค. 2022
Welcome to Ah Sing Excel TV.
Watch and learn Excel for free at anytime anywhere. Over hundreds topics awaiting you!
Feel free to join Excel & VBA Discussion Facebook Public Group 🤗 at groups/486402069483674. Feel free to raise/ask questions (if any) or share knowledges and Excel tricks, sharing is caring! 😘
Topics that will be shared from time to time:
1. Features and settings of Excel
2. Excel functions
3. VBA
4. Combination of Excel functions
5. Creating a dynamic Excel templates
6. Problem solving (on request)
7. Ready-to-use files or Excel templates for free download
Watch and learn Excel for free at anytime anywhere. Over hundreds topics awaiting you!
Feel free to join Excel & VBA Discussion Facebook Public Group 🤗 at groups/486402069483674. Feel free to raise/ask questions (if any) or share knowledges and Excel tricks, sharing is caring! 😘
Topics that will be shared from time to time:
1. Features and settings of Excel
2. Excel functions
3. VBA
4. Combination of Excel functions
5. Creating a dynamic Excel templates
6. Problem solving (on request)
7. Ready-to-use files or Excel templates for free download
Circular Timer in Excel 🔥 How to write macro or VBA code in Excel 🔥 Animated Timer in Excel #excel
How to create a digital timer in Excel?
How to update time in real-time automatically?
Countdown timer on UserForm 👉 th-cam.com/video/N27jdMjjDXk/w-d-xo.html
Excel & VBA discussion public group 👉 groups/486402069483674
Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗
#excel #vba
How to update time in real-time automatically?
Countdown timer on UserForm 👉 th-cam.com/video/N27jdMjjDXk/w-d-xo.html
Excel & VBA discussion public group 👉 groups/486402069483674
Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗
#excel #vba
มุมมอง: 162
วีดีโอ
Create digital clock that updates time in real time using a UserForm #excel #vba
มุมมอง 184หลายเดือนก่อน
How to create a digital clock on a calendar? How to update time in real-time automatically? How to run macro without stopping users from editing? Countdown timer on UserForm 👉 th-cam.com/video/N27jdMjjDXk/w-d-xo.html Excel & VBA discussion public group 👉 groups/486402069483674 Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗 #excel #vba
All functions for values lookup in Excel🔥LOOKUP🔥VLOOKUP🔥HLOOKUP🔥XLOOKUP & more #exceltips #function
มุมมอง 862 หลายเดือนก่อน
All functions that can be used in value lookups. Conventional lookup method: LOOKUP, VLOOKUP and HLOOKUP. Advanced lookup method: INDEX & MATCH. New lookup method: XLOOKUP, CHOOSE, TAKE, DGET and FILTER. Excel & VBA discussion public group 👉 groups/486402069483674 Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗 #Excel #tips #microsoft
Use custom Function in Excel 🔥 Logical test between number and text #excel #vba #tips
มุมมอง 852 หลายเดือนก่อน
How to use Evaluate Function as an Excel Function? How to compare value and text? How to create a custom function in Excel? How to perform logical test in Excel? How to write VBA macro code? Excel & VBA discussion public group 👉 groups/486402069483674 Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗 #excel #vba #exceltips
Disable delete, copy-paste, right-click & hide ribbon #Excel🔥stop users from delete row/column #vba
มุมมอง 962 หลายเดือนก่อน
An alternative way to protect formula without protecting worksheet. How to disable the "Delete" key in Excel? How to disable the delete option in Excel? How to disable copy-paste and cut function in Excel? How to disable right-click in Excel? How to hide ribbon conditionally in Excel? How to prevent users from deleting rows or columns in Excel? Excel & VBA discussion public group 👉 facebook.com...
Easiest way to insert checkbox, check or reset all checkboxes🔥checkbox in formula #excel #vba
มุมมอง 2332 หลายเดือนก่อน
Mechanize the process of inserting thousand over checkboxes and assign cell links by using VBA. How to insert 1000 over in-cell checkboxes and assign cell links in one minute? How to assign link cell using VBA? How to involve checkboxes in formula? How to create in-cell checkbox in Excel and check or reset all checkboxes in one click? 👉 th-cam.com/video/M1HL_7aLRUs/w-d-xo.html How to reset all ...
Dependent dropdown list (dropdown menu) on Excel VBA UserForm #excel #vba #microsoft
มุมมอง 1143 หลายเดือนก่อน
How to create dependent dropdown list or combo box on Excel UserForm? How to provide options based on the selection on the other combo box? How to create dropdown list on UserForm using Excel combo box? Multi-select dropdown menu 👉 th-cam.com/video/P8l-2IbO9Bo/w-d-xo.html Auto-update dropdown menu (with & without VBA) 👉 th-cam.com/video/aypLwGoioAk/w-d-xo.html Excel & VBA discussion public grou...
Assign ListBox items to active cell🔥Add items to ListBox🔥Unselect items🔥Table to listbox #excel #vba
มุมมอง 1443 หลายเดือนก่อน
How to create multi-select dropdown list using List Box? How to send the items from a List Box to a cell? How to determine the previous active cell? Multi-select in-cell dropdown menu in Excel 👉 th-cam.com/video/P8l-2IbO9Bo/w-d-xo.html Excel & VBA discussion public group 👉 groups/486402069483674 Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗 #...
Multi-select ComboBox dropdown menu on UserForm #vba #excel
มุมมอง 7243 หลายเดือนก่อน
How to create multi-select dropdown list on UserForm using Combo Box? How to select multiple items from a dropdown list? How to exclude selected items from the dropdown list? Multi-select in-cell dropdown menu in Excel 👉 th-cam.com/video/P8l-2IbO9Bo/w-d-xo.html Excel & VBA discussion public group 👉 groups/486402069483674 Welcome to join and feel free to raise/ask questions (if any)...
How to create dependent drop down list in Excel #excel #tricks #dynamic
มุมมอง 2273 หลายเดือนก่อน
How to create dependent dropdown list in Excel? How to provide options based on the selection on the other cell? How to create dropdown list using data validation? Multi-select dropdown menu 👉 th-cam.com/video/P8l-2IbO9Bo/w-d-xo.html Auto-update dropdown menu (with & without VBA) 👉 th-cam.com/video/aypLwGoioAk/w-d-xo.html Excel & VBA discussion public group 👉 groups/486402069483674...
How to create 100% secure workbook? ZIP method to crack password fails if you do this! #excel #VBA
มุมมอง 2084 หลายเดือนก่อน
How can I protect my Excel worksheets and workbook so that the password cannot be cracked? How can I protect and lock my Excel VBA code so that the password cannot be cracked? How to prevent Excel workbook from cracking? How to stop password cracking? Decrypt file without password 👉 th-cam.com/video/nOAwW8ZtSGU/w-d-xo.html To protect and unprotect workbook and worksheet while giving limited acc...
#latest Unprotect Excel sheet without knowing the password🔥 Work on Office 365 & Windows 11 #excel
มุมมอง 1944 หลายเดือนก่อน
Unprotect excel sheet without knowing the password. Unprotect workbook and worksheets without password. Trick to unprotect Excel workbook without password. Trick to unprotect Excel worksheet without password. Protect Excel worksheets, workbook and VBA that the password cannot be cracked?👉 th-cam.com/video/kV9HHZ5edks/w-d-xo.html Decrypt file without password 👉 th-cam.com/video/nOAwW8ZtSGU/w-d-x...
Remove VBA password without password 🔥 unlock VBA project without password #excel #password #vba
มุมมอง 1K4 หลายเดือนก่อน
Remove VBA password without password 🔥 unlock VBA project without password #excel #password #vba
How to convert number to words in Excel #excel #worksheetfunction
มุมมอง 825 หลายเดือนก่อน
How to convert number to words in Excel #excel #worksheetfunction
Excel shortcut keys | Excel Efficiency: 100 Keyboard Shortcuts You Need to Know #excel #shortcutkeys
มุมมอง 1065 หลายเดือนก่อน
Excel shortcut keys | Excel Efficiency: 100 Keyboard Shortcuts You Need to Know #excel #shortcutkeys
How to write VBA code in excel | Run macro on cell value change 🔥Format cell with VBA #excel #vba
มุมมอง 775 หลายเดือนก่อน
How to write VBA code in excel | Run macro on cell value change 🔥Format cell with VBA #excel #vba
Check/uncheck all checkboxes with a single 'checkbox' #excel
มุมมอง 9176 หลายเดือนก่อน
Check/uncheck all checkboxes with a single 'checkbox' #excel
Create translating function for all versions of Excel | How to get element from html? #excel #vba
มุมมอง 1376 หลายเดือนก่อน
Create translating function for all versions of Excel | How to get element from html? #excel #vba
Fully dynamic Excel calendar control | A date picker #excel #tips
มุมมอง 1.3K7 หลายเดือนก่อน
Fully dynamic Excel calendar control | A date picker #excel #tips
Save Excel UserForm as picture during run time using VBA
มุมมอง 5568 หลายเดือนก่อน
Save Excel UserForm as picture during run time using VBA
Print or Save Excel UserForm as PDF file during run time using VBA
มุมมอง 3.5K9 หลายเดือนก่อน
Print or Save Excel UserForm as PDF file during run time using VBA
Dynamic Gantt chart for workplan in Excel #smartcharts
มุมมอง 669 หลายเดือนก่อน
Dynamic Gantt chart for workplan in Excel #smartcharts
How to include quotation marks in string expressions in VBA
มุมมอง 2839 หลายเดือนก่อน
How to include quotation marks in string expressions in VBA
Transfer values from one UserForm to another
มุมมอง 3029 หลายเดือนก่อน
Transfer values from one UserForm to another
Prompt Message Box conditionally in Excel
มุมมอง 19310 หลายเดือนก่อน
Prompt Message Box conditionally in Excel
Excel Histogram with unequal class bins' widths ✅
มุมมอง 34610 หลายเดือนก่อน
Excel Histogram with unequal class bins' widths ✅
This is amazing, thank you so much
My pleasure. Thanks for watching. Wish you a wonderful day.
So the last row filled with name can stay without contact nor email?
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!
when i change extension xlms to zip than did not work.
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: th-cam.com/video/z9PeiAz33r0/w-d-xo.html. I hope it helps you. Thanks for watching, and have a wonderful day!
This was very helpful. Thank you!
My pleasure. Thanks for watching. Wish you a wonderful day.
How to save this trick in Excel
Hi! If you want to apply this trick to all your workbooks, you might find this method helpful: th-cam.com/video/A8bpF3RhF-U/w-d-xo.html. I hope you find it useful. Thanks for watching, and have a wonderful day!
Thank you boss🤝🤝🤝
You’re most welcome, boss 🤝🤝🤝
Thanks learnt something new
My pleasure. Thanks for watching. Wish you a wonderful day.
excellent! it worked. thank you so much :)
Thanks! It is my pleasure to share with you. Thanks for watching. Wish you a wonderful day.
Hey this tutorial seems to be right for me, but I can't get it to work. I wanted to download your file, but I don't have fb.. could you upload it to another space please?
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.
For some reason the macros in my workbook where deleted. This works. Thanks
My pleasure. I'm glad it helps you. Thanks for watching. Wish you a wonderful day.
thanks help full
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
trying this it gives me "The password you supplied is not correct. Verify that the Caps lock key is off and be sure to use correct caprification. it does not start the module when running it
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! Thank you for the code! My excel work book is opened via a macro in Outlook. Everytime I run the Outlook macro the Excel wb onpens and the msg box "You need a password to save this workbook" appears. How can I stop this from happening?
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 😊
Very well paced, well spoken, and the visuals for inputs even simple ones like control+c and control+v are so helpful and a wonderful addition. Thank you for this video much success wished your way, may you educate other people successfully 🙏
Thanks! I'm glad you like it 🙏 Thanks for watching. Wish you a wonderful day.
Amazing
Thanks! Thanks for watching. Wish you a wonderful day.
I did it but not working
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.
love it, direct to cell😃
I'm glad you like it. Thanks for watching. Wish you a wonderful day 😀
I want 4 columns to be selected as date.
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.
How to reverse it??
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.
Known issues: 1. Error where variable is not defined. Suggestion: Delete the newly created blank sheet, save your workbook, close and reopen it. Then, run the code again. If the error persists, add 'ws.Select' before 'ws.Paste' and check the second point. 2. PDF file gets corrupted when opened. Suggestion: Add the parameter 'ActivePrinter:="Microsoft Print to PDF"' before 'PrToFileName' so that Excel will convert the file to PDF for you. Hope you find this information useful. Thanks for watching and have a wonderful day!
so helpful
Glad it was helpful! Thanks for watching. Wishing you a wonderful day.
Sir you are amazing But it would be great if you an indent like If something then For i = 1 to 5 Range("A" & i) = "Good" Next i End if Also you can use single like If Statement like If i = 0 then i = 1 Without end if ❤
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
Exactly what i want for my calendar, but if Code is running , it effect the performance of the system, is their any other method I also tried Application.OnTime Which is also work, but if their is any other efficient method you know then please share with us
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.
Thank you so much. I learned it from you and it works for my file.
My pleasure. Glad it helped. Thanks for watching. Wishing you a wonderful day.
Great!
Thanks! Thanks for watching. Wishing you a wonderful day.
i copied as it is VBA code but when i run the same , getting error as Variable not defined
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.
i am getting error WS variable not defined - any one can help me
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, great video. I want to apply the list box to different sheets (2 or more worksheets), Can you teach me how to do that? Thanks
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
Great!
Thanks! Thanks for watching. Wishing you a wonderful day.
so flippin hard
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.
I am not sure , Whether passowrd only 2 char or more char ? How to apply for this case ?
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.
Genius. Saved me so much time thank you
My pleasure. Thanks for watching. Wishing you a wonderful day.
I get a text behind the buttons that says “true” when selected and “false” when unselected, and i want to hide the text can you please tell me how ? I followed all your steps and i’m using activex
Hi. Is this what you are looking for: th-cam.com/users/shorts50I9cTBYGac?feature=share? I hope it is useful. Thanks for watching, and have a nice day.
Sir how to write any text Upper case, lower case & proper case of any textbox of vba userform
Hi there! The functions for upper case, lower case, and proper case in VBA are UCase(String), LCase(String), and StrConv(String, vbProperCase) respectively. For example, if you want to capitalize all words in TextBox1 of UserForm1, simply double-click on the textbox and type: Me.TextBox1 = UCase(Me.TextBox1). Hope this explanation helps. Thanks for watching, and have a nice day.
Thank you sir
My pleasure 😊
@@ahsing_excel_VBA YOU ARE A LIFE SAVER I NEEDED EXCATLY THIS FOR A PROJECT !!!!!!!<3
Can checkboz apply vba code I want to one check box when I click 3 specific name check box auto tick how I do this task
Hi. Yes, use the checkbox under ActiveX Controls. Then, while the 'Design Mode' is on, double-click on the checkbox and use an 'If' statement to set the condition to check the three checkboxes. Hope this helps. Thanks for watching, and have a nice day.
Amazing...English I REALLY CANT UNDERSTAND and I CANT FOLLOW
Too bad. This is the limitation of Shorts where I can't explain it in detail. My original script is more than a minute long. However, because this is a Short, I must trim the portions that I think are unnecessary. The analytics showed that 94.5% of viewers could follow. Therefore, I didn't make a video on this topic. Maybe you can try following the texts/instructions that I typed on the video. I'm sorry that I wasted your one minute. By the way, I wish you a nice day.
Worked liked a charm !!
Thanks for watching and have a nice day.
Is there a way to click multiple of those options without clicking the drop-down multiple times? For instance, you just click the drop-down once and select multiple options at the same time then all the options appear in the box.
Hi. In that case, you might need a List Box. Thanks for watching and have a nice day.
@@ahsing_excel_VBA Can you make a video of it. Or, if you've already made one, can you post the link.
Hi. Here it is: th-cam.com/video/npcOckscFgc/w-d-xo.html. I hope it's not too late for you.
Hello nice video, is working for me UserForm1 but is not working for me UserForm2 and Userform3, can you help me
Hi. I guess you have forgotten to call the module in each UserForm, just like at 1:07. Hope this resolves your issue. Thanks for watching and have a nice day.
Can it could be used with notepad without hex editor?
Hi. For older versions of Excel, I believe it can be done since I've done it before with version 2010. If you're asking about Office 365, I don't think it's possible based on my experience, as it will corrupt the file.
I did all steps but it did not open the file ,and was saying file may be corrupted.
@@angel-hb8wl In that case, 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. Have a nice day.
This is a great tutorial and what I need for a project at work. I have to create numerous groups of 3 options for a tool. I prefer to use activex instructions. What if I wanted to name each each option button. For my example I have multiple groups of 3 option buttons, named 'yes' 'no' 'incomplete'. .object.caption = "Yes" but I am unsure how it would populate for the no and incomplete.
Hi. You can create a variable, let's say 'm', with an initial value of 1, and then use 'm = m + 1' to update it from 1 to 3. Next, use an 'if' statement to set it as 'Yes', 'No', or 'Incomplete'. Finally, reset 'm' to 1 when it reaches 3. Hope this helps. Thanks for watching and have a nice day.
Very nice video 👏
Thanks! Thanks for watching and have a nice day.
Thanks for this, this is what I'm looking for
My pleasure. Thanks for watching and have a nice day.
Can you just comment tge whole vba code
Hi. Sorry to say that I typically don't share macro codes that are short or require customization, preferring to demonstrate step-by-step instructions instead. Thanks for watching and have a nice day.
Oh it's really okay, after watching many videos I landed up watching your video and it was really helpful thanks for sharing this video.
How should add more precision to the stopwatch to 1/100 sec? ¿Just add 2 decimals to the secs? Thanks!
Hello! When dealing with milliseconds, utilizing the 'Sleep' function is essential. You can find a demonstration video at th-cam.com/video/Phh9zyCIOEA/w-d-xo.html. Keep in mind that the 'Sleep' function's performance may vary across different computers due to differences in their systems. I hope this information is helpful. Thank you for watching, and have a wonderful day!
@@ahsing_excel_VBA Thanks. I will take a look into it. Regards
Amazing thanks sir ❤❤
My pleasure and thanks ❤️❤️ Thanks for watching and have a nice day.
Hello there, great video :) Can you please help me with this situation? I have a module, that will delete all content in certain cells in my form, but i need to also reset the value of the check box to "uncheck". My code: Sub ClearForm() ' ' ClearForm Makro ' Výmaz údajů zadaných ve vstupním formuláři pro vystavení faktury. ' ' Klávesová zkratka: Ctrl+q ' Range("D5:D25").Select Selection.ClearContents ActiveWindow.SmallScroll Down:=28 Range("B38:D72").Select Selection.ClearContents ActiveWindow.SmallScroll Up:=30 End Sub Is there any possibility to insert your code into mine? Thank you :)
Hello there. Thanks! :) Can insert the code before 'End Sub'. Hope this helps. Thanks for watching and have a nice day.
do i really need to assign all the checkboxes manually?, what if i have hundreds and thousands checkboxes?, any other way to do it automatically?
Hi. Yes, indeed! Fortunately, we can accomplish this task quite easily with VBA. Simply click on the related video link, and you'll discover the solution. Thanks for watching and have a nice day.
Interesting approach!
Thanks! Thanks for watching and have a nice day.