This was great. I tried it. It works. As soon as I try to call one of the functions from my personal.xlsb, it tells me they aren't in the project that that is what I am working expressly out of. Any ideas?
Hello, what a good contribution, now I have 2 queries, please if you could help me: 1.- delete the first option "cut" how can I put it back? 2.- When I right click on a cell that is inside a table, the option I put does not appear, it only appears when I right click on a cell that is not in a table. 3.- Do you have a video that can do this option from the Custom UI program? Could you help me please?
Hello Pamai! Great videos as usual... By some reason i can make it work with Cell context menu, but the OnAction for the VBE.CommandBars("Code Window") sub menu does not fire the routine... Is there any particularity that needs to be addressed in the OnAction for the VBE ? Thanks in advance!
Copy paste the code into your Personal Workbook and have it run on Workbook open event. Suggestion:- better use .xlam file (add-in file) and install addin rather then using 'Personal Workbook'
VBA A2Z i am waiting, now it’s the beat period to watch videos because we are in quarantine and it look we are going to stay like this for at least 1 month
@@scotolivera8207 that's correct. I'll try and cover this too in future but if I go about it I'll create custom calendar (with labels/buttons) move all objects within a frame and position them dynamically using code. for example next to date textbox. The same object can then be added to toolbox so next time you need it you can access it from there.
VBA A2Z thanks for you guidance, hope to see you building it bcz I think everyone who is trying to build a project with vba have face a problem with the date picker
Sir this channel is going to be the reference for all vba things, seriously
Thanks, George for your kind words.
Another great tutorial ❤
Thank you! Cheers!
thanks!
interesting topic. will be waiting for next episode.
Glad you liked it!
There is NO video explaining how it start it in VB Studio
thanks sir. Looking forward to ribbonx and VBE codes :)
Very soon!
This was great. I tried it. It works.
As soon as I try to call one of the functions from my personal.xlsb, it tells me they aren't in the project that that is what I am working expressly out of.
Any ideas?
try setting up add-in file if you want the right click on everyfile.
make sure the code is triggered in Workbook open event
Hello, what a good contribution, now I have 2 queries, please if you could help me: 1.- delete the first option "cut" how can I put it back? 2.- When I right click on a cell that is inside a table, the option I put does not appear, it only appears when I right click on a cell that is not in a table. 3.- Do you have a video that can do this option from the Custom UI program? Could you help me please?
Sir you are so great 👍😍
Thank you so much 😀
Not clear what references I need for Tools>References in order for the controls to work. Please help.
you'll need to reference Microsoft Forms *2.0* object library
Hello Pamai! Great videos as usual... By some reason i can make it work with Cell context menu, but the OnAction for the VBE.CommandBars("Code Window") sub menu does not fire the routine... Is there any particularity that needs to be addressed in the OnAction for the VBE ? Thanks in advance!
Hi Rui, assigning events to VBE menu is done via class. Please check here ruclips.net/video/wrrWMb34NAw/видео.html
Many thanks sir for outstanding video
So nice of you
Where do I get the .faceid download and how to use it?
Please find source code here vbaa2z.blogspot.com/2020/04/generate-face-id-on-runtime-using-vba.html
Hello Sir, this is method not working to page preview. How fix?
I haven't tried myself however it may not work in preview. Try ribbonX
How do you code it for a macro in a personal macro file
Copy paste the code into your Personal Workbook and have it run on Workbook open event.
Suggestion:- better use .xlam file (add-in file) and install addin rather then using 'Personal Workbook'
Thanks
No problem
Hope the next video is Custom Ribbon and context menu in XML
Check out VSTO Ribbon Series here including XML ruclips.net/p/PLo0aMPtFIFDqaRyd0KZ0DLXFD3rfhI4SU&pbjreload=102
When u are going to publish the next video in this series?
:) linning them up. I'll upload in evening or tomorrow.
VBA A2Z i am waiting, now it’s the beat period to watch videos because we are in quarantine and it look we are going to stay like this for at least 1 month
Can you please address the date picker problem for 64 bit excel , how to solve this issue
One option I see for VBA Developers would be to create a Custom Calendar like the way we created a Custom Table.
VBA A2Z i see , so you mean to create custom calendar (userform) and incorporate it into our vba project once we need it
@@scotolivera8207 that's correct.
I'll try and cover this too in future but if I go about it I'll create custom calendar (with labels/buttons) move all objects within a frame and position them dynamically using code. for example next to date textbox. The same object can then be added to toolbox so next time you need it you can access it from there.
VBA A2Z thanks for you guidance, hope to see you building it bcz I think everyone who is trying to build a project with vba have face a problem with the date picker
Sir, Video is very usefull, But in my Excel by my mistake Cut option has delete, Now how can I recover cut option. Please help.
try below.
Application.CommandBars("Cell").Reset
@@VBAA2Z It's working, Thank you so much Sir
How to put a FaceID to the "Demo"-menu? Thank you very much in advance!
Hi, I am not sure which demo menu you're referring to.
do you mind sharing more info? or your code perhaps.
Sir I request you to Please create a menu bar in next video.
Are you referring to UserForm floating menu?
Thank you for your wonderful lessons.
May you please post a lesson on how to add a command to cell shortcut menu when the cell is in edit mode
Are you referring to adding extra tool to edit Context menu?
@@VBAA2Z yes please
@@tonyhaddad1088 ok sure.
Talking about customizing things, please check your email, I have an interesting question for you.
replied.
Thank you, I have some ideas now