How to add Ctrl Z or Undo Feature for your VBA Projects. Free Project Download available

Подписаться 51 тыс.

Просмотров 9 тыс.

50% 1

Friendly VBA tutorial to how to add Ctrl Z or Undo Feature for your VBA Projects.
Free Project Download available: Subscribe, Like, and Comment.
🙏Thanks for watching.
You can now support by buying any of the Projects or Source Code.
📥Downloads: pamaitech.com/downloads/
👍 Support: paypal.me/pamaitech
✉️ Contact: contact@pamaitech.com
📌What to watch next:
Playlist: ru-vid.complaylists
Videos: ru-vid.comvideos
#VbaA2z

Наука

Опубликовано:

11 апр 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 116

@VBAA2Z 3 года назад

Project download will be made available soon. Do not forget to leave a like, comment and share if you find the video useful.

@VBAA2Z 3 года назад

089 VBA CTRL Z : How to add Ctrl Z or Undo Feature for your VBA Projects Have fun!

@azel2239 3 года назад

@@VBAA2Z submitted, thanks

@kiloonzjico7953 3 года назад

Absolutely brilliant tutorial, your contents are hidden treasures. Keep up great work!!!

@VBAA2Z 3 года назад

Thanks Kiloonz for your kind words and for your continued support.

@holieh5301 3 года назад

Thank you so much Pamai! This is crucial for any professional projects and Add-in utilities. Looking forward to implementation on this feature

@VBAA2Z 3 года назад

You're so welcome! thanks for your support

@djunabug 3 года назад

Amazing, as always, Lung. Thank you so much!!

@VBAA2Z 3 года назад

You're most welcome!

@arianjico4441 3 года назад

Hats off to you! Keep up the good work you're doing for community

@VBAA2Z 3 года назад

Thanks for your support and encouragement

@z.719 2 года назад

This is awesome! Thanks for great tutorials!

@VBAA2Z 2 года назад

Thanks!

@vs_gaming3013 3 года назад

Brilliant! Thank you for all this info you share!

@VBAA2Z 3 года назад

Glad it was helpful! thanks for watching

@GoncaloFly 3 года назад

Thanks for sharing your knowledge with us. Cheers!

@VBAA2Z 3 года назад

So nice of you, happy to share what I know. Thanks for your support.

@Rahul-sn1wn 3 года назад

Amazing work Pamai. Thank you for sharing your knowledge

@VBAA2Z 3 года назад

Much appreciated

@hoseal8048 3 года назад

Thanks sir for informative, insightful and realistic tutorials. Of course I will like share and comment.

@VBAA2Z 3 года назад

Awesome, thank you!

@davidpacheco2657 3 года назад

Incredible content as always!

@VBAA2Z 3 года назад

Much appreciated!

@kingsoko5319 Год назад

You're great 👍 Thank you so much for valuable contribution to VBA community

@VBAA2Z Год назад

Thanks and welcome

@benjaminf5731 Год назад

another great video. thank you

@VBAA2Z Год назад

Glad you enjoyed it

@scottymars3289 3 года назад

You're the best. You do magic with VBA

@VBAA2Z 3 года назад

thanks for your kind words.

@scottymars3289 3 года назад

@@VBAA2Z you're welcome!

@azel2239 3 года назад

Another useful video, thank you so.. much

@VBAA2Z 3 года назад

Glad it was helpful! thanks for watching.

@user-ll8up1eu4d Год назад

great video thanks!

@VBAA2Z Год назад

You're welcome!

@ME-dh6yh 3 года назад

As always a great tutorial to learn from.

@VBAA2Z 3 года назад

Thanks again!

@kinga334 3 года назад

Absolutely amazing stuff. One request, pleasure some more videos on VSTO.

@VBAA2Z 3 года назад

Thanks! Will do!

@SaraPerzYT 3 года назад

You’re the man 👏👏👏

@VBAA2Z 3 года назад

Thanks for your support 🙂

@aakashpriyadarshi5120 2 года назад

Very very Informative Tutorial.

@VBAA2Z 2 года назад

Many many thanks

@perymdiso1006 3 года назад

Interesting video. Thanks as always

@VBAA2Z 3 года назад

Glad you enjoyed it

@joybyu1231 3 года назад

Thanks for sharing your knowledge so freely. Please add some advance series on pivot tables too

@VBAA2Z 3 года назад

Will do soon. thanks for watching.

@marcelorebel 2 года назад

Very Nice. Congratulations

@VBAA2Z 2 года назад

Thank you! Cheers!

@silunewmai9017 3 года назад

Great contents. Keep it up

@VBAA2Z 3 года назад

Thanks, will do!

@franciscosolorzano3673 3 года назад

Hola Muchas gracias. Tema muy interesante..!

@VBAA2Z 3 года назад

You're most welcome!

@KhalilYasser 3 года назад

Thank you very much.

@VBAA2Z 3 года назад

You are welcome!

@beginho2454 3 года назад

great teacher

@VBAA2Z 3 года назад

Thank you! 😃

@andresfelipecollazoscordob4525 2 года назад

Increíble trabajo amigo

@VBAA2Z 2 года назад

Gracias mi amiga!

@ekilunewmai7033 Год назад

Thanks for useful video

@VBAA2Z Год назад

Welcome

@noellecjaski5037 3 года назад

Nice work 👍

@VBAA2Z 3 года назад

Thank you! Cheers!

@DidamNb Год назад

Thanks Pamai

@VBAA2Z Год назад

most welcome

@mswordexpert 2 года назад

Thanks

@VBAA2Z 2 года назад

Welcome

@melivo853 3 года назад

Thank you so much. Please make tutorials Pivot table automation.

@VBAA2Z 3 года назад

Ok coming soon

@clip1075 4 месяца назад

thanks

@VBAA2Z 4 месяца назад

You're welcome!

@NancyCa198-a 3 года назад

Thanks for great tutorials, would it be possible to create a custom menu to hold more undo perhaps a separate menu for VBA Undo?

@VBAA2Z 3 года назад

Great suggestion! you can store current state config in dictionary and have a dynamic menu which can act as 'VBA Undo Menu' RibbonX: ru-vid.com/group/PLo0aMPtFIFDqAIOHVLbaUNZf5abdqRPl4

@kamalagarashova9551 3 года назад

nice

@VBAA2Z 3 года назад

Thanks

@russprism Год назад

Will this work in a range that has formuals that are supposed to update automatically but are not to be changed manually?

@sorledecoder7867 3 года назад

Sir, I will like to suggest that you add comments to each sections to enable me a beginner to understand what the codes does. Thanks.

@VBAA2Z 3 года назад

Ok next time - thanks for your suggestion

@pelengwichewang7176 3 года назад

👍👍😊😊😊♥️

@VBAA2Z 3 года назад

thank you!

@rosswilliams6838 Год назад

Thank you Pamai, I was hopeful that I might access your script but find that Project 089 is not listed in the site you have indicated.

@VBAA2Z Год назад

We'll check and update the blog accordingly

@anhnhatnguyet4628 3 года назад

VBA excel, do you have any way to convert fonts from VNTime to Time new roman for THE SAME MULTIPLE EXCEL FILE in 1 folder?

@VBAA2Z Год назад

'm not aware of converting fonts. but you can update format (font, size) etc

@nghianguyenhoai5524 Год назад

i have a problem that i wanna undo before VBA code done. For example: I delete a row at the first time and deal with other jobs then i want that row appear again at the end of code so pls help me with tks!

@VBAA2Z Год назад

simply back the data and restore it when needed. Copy data to backup sheet ..... ..... Copy back from backup

@FitnFabulousLife 2 года назад

Will this also work if the vba code removes a row, adds icons to it and do multiple tasks

@VBAA2Z 2 года назад

will not revert objects like shapes unless you explicitly back them up...code will need to be modified

@MrPorkered 2 года назад

Thank you very much for this. how may I download this? I only see the response form.

@VBAA2Z 2 года назад

Please check video desc. for link

@FitnFabulousLife 2 года назад

How to take backup automatically before worksheet change event is triggered? If I change the value in cell A1 from "Hello" to "Bye" then I cant take backup of Hello because Bye is already there. Also this project is not available in projects to download section

@VBAA2Z 2 года назад

It is demonstrated in video. Also check here vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html

@russprism Год назад

How do you open the "immediate" box?

@purushottamjoshi5914 3 года назад

hi , can you please help me to create code for system lock and unlock time capture

@VBAA2Z 3 года назад

thanks for your suggestion. You can try using system startup, scheduler etc. also check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ZW5nlE7mj60.html

@davisnorton4163 2 месяца назад

where can I find this free download!??! Thanks

@VBAA2Z 2 месяца назад

please visit pamaitech.com/downloads/

@VBAA2Z 2 месяца назад

pamaitech.com/downloads/

@anhnhatnguyet4628 3 года назад

What about Redo (Ctrl Y)?

@VBAA2Z Год назад

good idea!

@jaku1798 2 года назад

Thank you for this. How can I download exactly this script? I can’t find this.

@VBAA2Z 2 года назад

Hi Jaku, please check here vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html

@jaku1798 2 года назад

@@VBAA2Z sorry but is not there. I look below comments and should be under number 087. Can you help? Thanks

@anhnhatnguyet4628 3 года назад

Upon downloading, I was asked to enter 2 pieces of information including my email and Project ID in the form. I don't know where to get Project ID

@VBAA2Z 3 года назад

vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html 089 VBA CTRL Z : How to add Ctrl Z or Undo Feature for your VBA Projects

@anhnhatnguyet4628 3 года назад

I have visited your link shared above. and stuck in the Project ID import

@VBAA2Z 3 года назад

@@anhnhatnguyet4628 in project ID simple type in 089

@anhnhatnguyet4628 3 года назад

@@VBAA2Z Therefore, it is. I understand

@anhnhatnguyet4628 3 года назад

@@VBAA2Z Featured post You can now support VBA A2Z by simply buying any of the Project / Source Code Free Projects or Source Code Request Form Please Subscribe, Like, and Comment to help our channel reach more people. Your request will be reviewed and processed as soon as possible. Please be sure to check the Spam folder in case you don't receive it in your Inbox. Please make sure your email id and project ID are correct. .............I received the same message as above, and I don't know what to do next

@thomasfergusen5144 2 года назад

Hello, i have a question: "thisworkbook.save" code takes alot of time (even i did "Application.CalculateBeforeSave = False" and "Application.Calculation = xlCalculationManual") so i decided to use that code only in "Private Sub Workbook_BeforeClose(Cancel As Boolean)" subroutine. But the problem is when electric is off or somehow programme get a runtime error vba does not read the code. ( i dont want to get recovery offering because of users not familiar that) so what to do? Thanks!