I absolutely love your videos. You're very thorough and to the point. Thank you for not spoofing about in your videos like many do on here. I'm a professional looking for serious tutorials, not "fun 'n games"; Please keep posting 🙏
@MyOnlineTrainingHub Жыл бұрын
Glad you like them! 🙏
@krismaly6300 Жыл бұрын
Thanks for educating the community and appreciate your volunteering and thanks to your tram
@MyOnlineTrainingHub Жыл бұрын
My pleasure 😊
@Romanis1337 Жыл бұрын
Excellent, thank you - would appreciate more vids like this, where you outline either a) super useful/complex macros in detail (generated by chatbot, or not) and/or b) more of a compilation vid of several macros and what they do/their effect accompanied by the code in description for easy use by us 🤔😊
@MyOnlineTrainingHub Жыл бұрын
Nice ideas 🙏 I’ll keep them in mind.
@LosoIAm Жыл бұрын
If you haven't not done it already, I would suggest copying the generated VBA code and place it in separate files (e.g. in Word) because ChatGPT generates different pieces of code all the time; I have found that sometimes I am off to a good start and get a bit close to the desired results, only to have it get me down another rabbit hole. Just what two cents.
@chrism9037 Жыл бұрын
Very cool Mynda. We're just scratching the surface of what the AI will be able to do in Excel!
@MyOnlineTrainingHub Жыл бұрын
Indeed, Chris. Times are changing rapidly.
@abmmozahid6797 Жыл бұрын
Your content is so helpful for me.Thank you so much ❤
@MyOnlineTrainingHub Жыл бұрын
My pleasure 😊
@steven.h0629 Жыл бұрын
Dang.. I've been the Macro King for decades, it used to be the only way to get things done in my environment.
@MyOnlineTrainingHub Жыл бұрын
😁it’s not replacing you yet.
@rob4433 Жыл бұрын
@@MyOnlineTrainingHubSteven, notice the word 'yet' lol
@iankr Жыл бұрын
Impressed that ChatGPT can do that! I use a similar macro that I've distributed to my colleagues at work. But I'd make just one small addition to that code. I check at the top of the macro that the selection is actually a range, to trap the error caused by the user inadvertently invoking the macro when (for example) a chart object is selected: If Typename(Selection) "Range" Then Exit Sub
@MyOnlineTrainingHub Жыл бұрын
Good point, Ian. Thanks for the tip.
@missamo80 Жыл бұрын
Brilliant! What a clever little trick to make it easier to center the Mynda-approved way :)
@MyOnlineTrainingHub Жыл бұрын
Glad you liked it!
@tmb8807 Жыл бұрын
Oh wow, had no idea about this. The possibilities are intriguing. Thanks!
@MyOnlineTrainingHub Жыл бұрын
Our pleasure!
@IvanCortinas_ES Жыл бұрын
Excellent practical application of AI. Thank you Mynda!
@MyOnlineTrainingHub Жыл бұрын
Glad you like it!
@MiRofek Жыл бұрын
YOU ARE GOOOD! Excellent tutorial.
@MyOnlineTrainingHub Жыл бұрын
Thank you! 😊🙏
@aloobi Жыл бұрын
I'm an advanced Excel user. Most of the time whenever I watch an Excel video, I don't learn anything new because I already know the stuff. But it's different with your videos. I always learn something new!
@MyOnlineTrainingHub Жыл бұрын
Wow, that's awesome to hear 🙏
@alexanderbaranov5418 Жыл бұрын
Interesting approach... Thank you
@MyOnlineTrainingHub Жыл бұрын
Cheers 🙏
@volkerschuster8079 Жыл бұрын
Incredible video as always....thank you Mynda
@MyOnlineTrainingHub Жыл бұрын
Glad you enjoyed it 🙏
@jerrydellasala7643 Жыл бұрын
Awesome. I don't know when Center Across Selection became available, but I only found it a couple of years ago after using Excel for decades and hating Merge & Center. I had a simple one line Macro that I had assigned to the QAT, but this macro is much better! Thanks!
@MyOnlineTrainingHub Жыл бұрын
Glad I could help! I won’t tell you how long center across selection has been around because you’ll cry 😭 😊
@Pfupfi59 Жыл бұрын
Great work by Chat GPT and you bringing it about in a understandable way
@MyOnlineTrainingHub Жыл бұрын
Glad you liked it 🙏
@AndresHortillosa Жыл бұрын
Always informative and so useful. I will download it myself.
@MyOnlineTrainingHub Жыл бұрын
Great to hear!
@LuisCarlosChavez717 Жыл бұрын
You're awesome, thank you! Excel and you make my job so much easier.
@MyOnlineTrainingHub Жыл бұрын
Wonderful to hear that 🙏
@Earth-360 Жыл бұрын
Good as always
@MyOnlineTrainingHub Жыл бұрын
Thanks so much!
@josecarlosconejo5724 Жыл бұрын
Very nice video. I will give good use to the learnings 😊. I would suggest videos on how to link Excel with Power Point using VBA or one to name VBA functions without the PERSONAL!… prefix
@MyOnlineTrainingHub Жыл бұрын
Great suggestion!
@Cycle1001 Жыл бұрын
Brava!
@MyOnlineTrainingHub Жыл бұрын
Thank you!
@MagicJim Жыл бұрын
Hi Mynda, I'm going to give ChatGPT a try to create the same macro but using Excel Automate Scripting instead of VBA.
@MyOnlineTrainingHub Жыл бұрын
Great idea 👍
@MegaTrickykid Жыл бұрын
great as always! thank you very much indeed. I now also use "CHATTY" almost daily to create VBA or python script and I am very content with the results. CHATTY is a fine chap 😄
@MyOnlineTrainingHub Жыл бұрын
Interesting! I’ll have to check it out 🙏
@erikguzik8204 Жыл бұрын
Really like this macro, I should have done this a long time ago Side note: as i step through VBA Code many times, i have set a button on my mouse to do the key stroke F8. now I just need to make this macro the 8th item on my QAT. so i can select the cells, hold ALT and click the mouse button (so its like ALT F8 - to use the 8th item in QAT)
@MyOnlineTrainingHub Жыл бұрын
Great to hear!
@ahmadalali96 Жыл бұрын
gooooorgeous 🌷🌷🌷
@MyOnlineTrainingHub Жыл бұрын
Thank you! 😊
@Everyonelovesyou Жыл бұрын
Another extremely useful video. I am new to VBA, and each time I ask chat Gpt to write a VBA code. No matter how specific I am in asking question it still do not work. Please tell us some basics of VBA to get benefited from chat GPT.
@MyOnlineTrainingHub Жыл бұрын
You might get better results if you break the process you want automated into smaller steps.
@msquarehaiti Жыл бұрын
Amazing!
@MyOnlineTrainingHub Жыл бұрын
Thanks!
@vlookup_tim Жыл бұрын
Thanks for sharing this macro. I’ve asked ChatGPT and the Google equivalent for a macro that cycles through a range of transaction details and determine which items agree in aggregate to a summary number from the bank statement. Alas, no success yet.
@MyOnlineTrainingHub Жыл бұрын
Yeah, it still has a way to go, but sometimes it’s amazing what it can do. BTW, love your name 😜
@sachin.tandon Жыл бұрын
I looked at this again, and seeing if a chain can be set off, by using python to open the excel files (say a batch of them) (using ChatGPT to do the heavy lifting), and then call any VBA macros from the Personal workbook, since somethings Python isn't as good at, as VBA (but you can the use Python to call VBA, which is a powerful combination!)
@MyOnlineTrainingHub Жыл бұрын
Interesting use case and great to know ChatGPT was helpful. You might also like to check out Power Automate to do this type of automation.
@janithb130911 ай бұрын
Nice trick..can you please also share a similar example for a rolling month function. I guess that function for now does not exists on Excel
@MyOnlineTrainingHub11 ай бұрын
See this video for rolling periods: kzfaq.info/get/bejne/iM6bf5RiupzefZc.html
@LosoIAm Жыл бұрын
Many thanks for the "Easily Create a PERSONAL.XLSB Workbook" tutorial; I didn't know XLSB can store VBA code. A question that I have is: in a virtual environment (Citrix, e.g.), if the servers are a bit tired, they can strip your VBA code from your XLSM files. Do you know if XLSB is immune to such behaviour?
@MyOnlineTrainingHub Жыл бұрын
Glad it was helpful! I wasn't aware of the VBA removal in virtual environments. Although it's likely to be a malware prevention process than tiredness 😊 You'd have to test .XSLB files to see it they're scrutinised in the same way as I don't have any virtual environments that I can test on.
@LosoIAm Жыл бұрын
@@MyOnlineTrainingHub Thank you very much indeed.
@patricklinnett1819 Жыл бұрын
Will this work across multiple workbooks, or is it just the one you were using at the time? Does the workbook have to be macro enabled?
@MyOnlineTrainingHub Жыл бұрын
It works in any workbook (no need to enable it) because you save it to your Personal workbook as shown in the video.
@patricklinnett1819 Жыл бұрын
@@MyOnlineTrainingHub ah, awesome! Thanks for the reply. I must have missed that - that's what I get for watching KZfaq at work, haha!
@Weehawk Жыл бұрын
I'd like a macro that unwinds Let functions.
@MyOnlineTrainingHub Жыл бұрын
Interesting idea 🤔
@adilali9567 Жыл бұрын
Hi. Just came across your video. With AI possibilities are unlimited. Can you just make a video and guide us how to automate making of T-Account in excel from the journal entries
@MyOnlineTrainingHub Жыл бұрын
Indeed they are. I don't have any plans for a t-account generator, but it'd be interesting to see if AI can help you build it.
@brianbambrick-sattar3688 Жыл бұрын
which Chat GPT do you recommend - keep up the great work
@MyOnlineTrainingHub Жыл бұрын
I just used whatever the current version is.
@modalities Жыл бұрын
Wonderful.
@MyOnlineTrainingHub Жыл бұрын
Many thanks!
@mikeot Жыл бұрын
Firstly. Thanks for all your great content, newsletters etc! I created personal macro workbook thinking that would be great because I could create and access macros without having to save .xlsm workbooks. But now I get "Personal.xlsb is locked for editing ..." every time I try to open Excel, so what can I do about that?
@MyOnlineTrainingHub Жыл бұрын
I’d reboot your PC. Hopefully that will clear the lock.
@AndresHortillosa Жыл бұрын
Have you tried creating a data form like the one that comes in Excel for a project? Currently, I simply add the tool in the QAT.
@MyOnlineTrainingHub Жыл бұрын
No, not yet.
@VenemAcademy Жыл бұрын
This is great thnx. But is this personal macro also available in any ordanary .xlxs file or is it only available in .xlxm files? My company restricted the use of macros to a near minimum, so it would great to use it anytime. Perhaps is it also in Type- or Officescript possible?
@MyOnlineTrainingHub Жыл бұрын
It's available in any Excel file you open on your PC because it is stored in your hidden Personal Macro workbook that opens automatically when you open Excel. You don't notice that it's open, but it's there running in the background for this very purpose.
@user-ui2su7im2y Жыл бұрын
Very good and many thx for all your video's. In this case I have small remark. The marco will run into an VB-error when selection all cells. As such it is better to change: Selection.Cells.Count to Selection.Cells.CountLarge. However than the system will 'hang' due to the big numbers of cells to check. As such a maximum needs to be add. So my proposal would be replace: ' Check if any cells are selected If Selection.Cells.Count = 1 Then MsgBox "Please select multiple cells to apply the formatting.", vbInformation Exit Sub End If by: ' Check if any cells are selected If Selection.Cells.CountLarge = 1 Then MsgBox "Please select multiple cells to apply the formatting.", vbInformation Exit Sub End If If Selection.Cells.CountLarge > 10000 Then MsgBox "Selection is limited to 10000 cells. Please make a smaller selection.", vbInformation Exit Sub End If
@MyOnlineTrainingHub Жыл бұрын
Thanks for sharing 🙏👍
@kevrush7823 Жыл бұрын
Will this only work on a macro enabled excel file?
@MyOnlineTrainingHub Жыл бұрын
No. It's saved in your Personal Macro Workbook and therefore available to work in any Excel file you have open on your desktop PC.
@sedigrasedigra4603 Жыл бұрын
Any luck to make chat gtp aligning the rows too? She didn't give up neither deliver the answer
@MyOnlineTrainingHub Жыл бұрын
You can't center across selection by row. For this we still have to use Merge & Center.
@sedigrasedigra4603 Жыл бұрын
@MyOnlineTrainingHub no magic from chat gtp then =(
@MyOnlineTrainingHub Жыл бұрын
No, ChatGPT can't make features that aren't already in the software.
@user-us6ld8oq6x Жыл бұрын
HI Mynda I can't find my personal macro and i get an error when I try to Follow your Instruction :"The personal macro folder in the startup folder must remain open to record" do you now what does it maen?
@MyOnlineTrainingHub Жыл бұрын
It means you don't have the Personal Macro workbook open. Usually when it's open it is hidden, so you don't realise it's there in the background. Did you follow these instructions to create your Personal Macro workbook? www.myonlinetraininghub.com/create-a-personal-macro-workbook-personal-xlsb
@user-us6ld8oq6x Жыл бұрын
@@MyOnlineTrainingHub Yes, I followed the instructions, but I couldn't record and received an error message as I wrote above. I managed to open the file directly from the operating folder, but only temporarily. it disappears again when I close Excel and reopen it.
@MyOnlineTrainingHub Жыл бұрын
The Personal Macro Workbook isn't usually visible when Excel is open. It runs in the background all the time once it is created.
@abmmozahid6797 Жыл бұрын
❤
@MyOnlineTrainingHub Жыл бұрын
🙏
@keylanoslokj1806 Жыл бұрын
Got a link for it?
@MyOnlineTrainingHub Жыл бұрын
In the video description. Here it is again: www.myonlinetraininghub.com/center-across-selection-macro
@keylanoslokj1806 Жыл бұрын
@@MyOnlineTrainingHub many thanks
@yulinliu850 Жыл бұрын
❤👍
@MyOnlineTrainingHub Жыл бұрын
🙏
@robrayborn1349 Жыл бұрын
All of them, all, all, all. Chat GPT can have macros. Getting the feeling I don't like macros??
@MyOnlineTrainingHub Жыл бұрын
I avoid macros where possible too, but this is a shortcut in your personal macro workbook so it doesn’t come with the problems you might get with other macros.
@IamTheReaper911 Жыл бұрын
😎
@MyOnlineTrainingHub Жыл бұрын
🙏
@DerickPitcher Жыл бұрын
Chat GPT helped me out with a quick request. I added about 30 buttons throughout my Excel app I built. I wanted to add a Tool Tip for each one so I asked Chat GPT if there's a quicker way to do this and it kicked out this VBA code (shown below) for me. I added the line wraps to reduce the width and removed the comments. I added it to my Quick Access Toolbar as well. Sub AddToolTip() ' Select a Shape, run this macro, and input your ToolTip in the popup window. Dim selectedShapes As Shape Dim toolTipText As String toolTipText = InputBox( _ Prompt:="Input a ToolTip for the selected shapes.", _ Title:="ToolTip Input") For Each selectedShapes In Selection.ShapeRange ActiveSheet.Hyperlinks.Add _ Anchor:=selectedShapes, _ Address:="", _ ScreenTip:=toolTipText Next End Sub