Video

This is available in the 365 edition. Yes, this function can work with numeric data as well. “[0-9]”: any numerical digit

You can include the characters ' or - in your REGEX pattern. Something like this... =REGEXEXTRACT(A1,"[A-Za-z'-]+$")

You can ask question in the Q&A section of the course you are taking. You can also ask questions here and I will do my best to answer them.

Awesome, thank you!

I have Microsoft course on Udemy.com

I just tired the link below the video and they work.

I just tired the links below the video and they work.

nevermind! found it.

Debug Error, Run-Time Error '9' Subscript out of range. Something wrong with "If Not Intersect(Target, Me.ListObjects("ProjectTable").ListColumns(3).DataBodyRange.Resize(, 2)) Is Nothing Then" It worked when I downloaded your file, but not on my own spreadsheet.

Unfortunately, it's a little difficult to help with problems on here because I cannot see your code or what is happening.

You can try using a little bit of VBA 1. Open the VBA Editor: - Press `Alt + F11` to open the VBA editor. 2. Insert a New Module: - In the VBA editor, go to `Insert` > `Module` to create a new module. 3. Add VBA Code: - In the new module, add the following code: Sub CalendarClick() Application.DisplayAlerts = False ' Your code to handle the calendar click and update the cell goes here ' For example, you might be setting a date in the selected cell: ActiveCell.Value = Date Application.DisplayAlerts = True End Sub This VBA code turns off alerts before setting the cell value and turns them back on afterward. You will need to adapt the middle part of the code to match what your calendar add-in does when a date is selected. 4. Assign the Macro to the Calendar Add-in: - If you are using a custom calendar add-in, you will need to find the event or button click that triggers the date selection and call this `CalendarClick` macro instead of directly setting the cell value. 5. Save and Close the VBA Editor: - Save your VBA project and close the VBA editor. 6. Test the Macro: - Go back to your Excel worksheet, trigger the calendar add-in, and select a date. The "Overwrite Contents" message should no longer appear. If the calendar add-in is a third-party tool, you might need to check its documentation or settings to see if there’s an option to integrate or call custom macros upon date selection. If this option is not available, you might need to handle the date selection process entirely through VBA as demonstrated. Remember to save your Excel file as a macro-enabled workbook (`.xlsm`) to ensure the VBA code is retained.

You're welcome!

Thank you for sharing!

You're Welcome! Thank you for watching!

Awesome thank you for sharing!

Is GBP your default currency on your system? You can select all the cell and change the currency symbol.

Can you share your formula?

Select the Text: Click inside the text box to place the cursor. Highlight the text you want to change the font size of. Change Font Size: Go to the Home tab on the Ribbon. In the Font group, click the Font Size drop-down menu. Select the desired font size from the list or type a specific font size in the box and press Enter. Alternatively, you can use the Mini Toolbar: After highlighting the text in the text box, a mini toolbar will appear near your selection. Use the font size options on the mini toolbar to adjust the size.

Thank you

Thank you!

It's just a regular calendar

If the checkbox feature in Excel is not accessible, there could be several reasons behind it. Here are some potential causes and solutions to help you troubleshoot the issue: 1. Worksheet Protection: - If the worksheet is protected, certain features, including inserting checkboxes, may be disabled. - Solution: Go to the Review tab and click Unprotect Sheet. If the sheet is password-protected, you'll need to enter the password to unprotect it. 2. Excel Version: - Some features might not be available in all versions of Excel, particularly if you are using Excel Online or a very basic version. - Solution: Ensure you are using a version of Excel that supports form controls. Full versions like Excel for Microsoft 365, Excel 2019, 2016, 2013, and 2010 support these features. 3. Add-ins or Macros: - Certain add-ins or macros might interfere with the normal functioning of Excel features. - Solution: Try disabling add-ins. Go to File > Options > Add-ins. At the bottom, select Excel Add-ins and click Go. Uncheck any add-ins and see if the checkbox feature becomes accessible. 4. Display Settings: - Sometimes, display settings or zoom level can cause UI elements to become inaccessible. - Solution: Try adjusting the zoom level of your worksheet or changing the display resolution of your monitor. 5. Developer Tab Visibility: - The checkbox feature is located under the Developer tab, which might not be visible by default. - Solution: To enable the Developer tab, go to **File** > **Options** > **Customize Ribbon**. Check the box next to **Developer** in the right-hand column. 6. Corrupted Excel Installation: - Your Excel installation might be corrupted or missing some components. - Solution: Try repairing your Office installation. Go to **Control Panel** > **Programs and Features**, find Microsoft Office in the list, and select **Change**. Choose **Repair** and follow the on-screen instructions. 7. Group Policy or IT Restrictions: - In a corporate environment, IT administrators may restrict certain features via Group Policy. - Solution: Contact your IT department to see if any policies are in place that restrict the use of form controls like checkboxes. 8. Compatibility Mode: - If you are working in a file that is in Compatibility Mode (an older Excel file format like .xls), some features may be disabled. - Solution: Convert the file to the newer .xlsx format by going to **File** > **Save As** and selecting the modern file format. By systematically checking these potential issues, you should be able to identify why the checkbox feature is not accessible in your Excel setup and take the appropriate action to resolve it.

Thank you! I do not plan on stopping anytime soon.

Unfortunately, I cannot help you if I cannot see your data or formula.

@@OfficeNewb how to send the data for analysis

Date formatting in Excel is pulled from the region/language settings on your computer, that is the default.

@@OfficeNewb its not that the date is clash.. now i need to make the form information for wedding event.. so i need to show to my lecturer when i click the date other than 1/1/2024-31/12/2024, it will show us the clash date to us🥺

You clicked on the link below the video to go to the Office Newb Blog? After you click on the link or copy and paste the link into your browser you will find the resource file there. Here is also a link to the Blog. www.officenewb.com/post/mastering-your-finances-the-snowball-debt-strategy

Thank you! Glad it was helpful!

If you look below the video, you will find a link to the Office Newb Blog that you can go to and download the resource file for this video.

Glad it was clear!

Are you clicking and dragging the lower right corner of the table to add rows?

Looks like it may only be available in excel 2013 or later. Have you tried to add it and it's not there to add?

Is this code work inside a table only?

Thank you

You can use a function like SUMIF

You're welcome!

Thank you! Glad you enjoyed the course.

They are great functions!

Thank you for watching. Not yet will put this on the list of videos to create!

@@OfficeNewb By the way. Google sheets, and I think the excel 365 have these baked in web data getting functions. Those CAN be great however, finding a web developer that still puts data into the <TABLE> section is getting fewer and fewer. Need to be able to scrape data from out of a CSS styled table. Also for God's sake if/when you do this I think you should also include how to login in to a personal acct of some sort so that people like me can automate reconciling their excel checkbook register and budgeting. Just an FYI

You're very welcome!

@@OfficeNewb How can I add more lines to the data entry table?

Thank you for watching!

Yes, it's possible to add data validation to a calendar object in VBA to prevent users from selecting a date earlier than today's date. You can achieve this by using a combination of the `BeforeUpdate` or `AfterUpdate` events of the calendar control and a condition to check the selected date. Here is an example of how you can implement this in VBA: Example with `BeforeUpdate` Event 1. Open your VBA editor (Alt + F11 in Excel). 2. Insert a new UserForm if you don't have one already. 3. Add a Calendar Control to your UserForm. If you don't see the Calendar Control, you may need to enable it from additional controls. 4. **Double-click the Calendar Control** to open its code window. vba Private Sub Calendar1_BeforeUpdate(Cancel As Integer) Dim selectedDate As Date selectedDate = Calendar1.Value If selectedDate < Date Then MsgBox "You cannot select a date earlier than today.", vbExclamation Cancel = True End If End Sub Example with `AfterUpdate` Event 1. Open your VBA editor (Alt + F11 in Excel). 2. Insert a new UserForm if you don't have one already. 3. Add a Calendar Control to your UserForm. If you don't see the Calendar Control, you may need to enable it from additional controls. 4. Double-click the Calendar Control to open its code window. vba Private Sub Calendar1_AfterUpdate() Dim selectedDate As Date selectedDate = Calendar1.Value If selectedDate < Date Then MsgBox "You cannot select a date earlier than today.", vbExclamation ' Optional: Reset to today's date Calendar1.Value = Date End If End Sub Explanation - Calendar1_BeforeUpdate: This event is triggered before the calendar value is updated. The `Cancel` parameter allows you to cancel the update if the condition is met. - Calendar1_AfterUpdate: This event is triggered after the calendar value is updated. Here, you can check the selected date and, if it's earlier than today, you can show a message and reset the calendar value to today's date. Both methods effectively prevent the user from selecting a date earlier than today's date. You can choose the one that best fits your application's flow.

Awesome! Glad you are enjoying the course!

Nice! Some tricks are pretty cool!

You're very welcome! Glad you enjoyed the course!

Thank you very much!

Very Nice!

Yes you can use a Note instead of a text box.

Wow, thank you!

Wow, thank you!