How to create a Data Entry Application using ChatGPT in MS Excel and VBA
Vložit
- čas přidán 7. 07. 2024
- In this tutorial, we will learn how to use ChatGPT to generate VBA code to develop data entry application in MS Excel and VBA. We will be providing some prompts to ChatGPT so that it can generate the VBA Codes.
You can visit to the below link to download the Excel file and Prompts used in this tutorial.
thedatalabs.org/create-data-e...
#thedatalabs #dataentryform #chatgpt #excel
www.thedatalabs.org.
Thanks for watching! Please like, share, comment and subscribe.
Disclaimer: This tutorial is designed for educational purposes only and is meant to demonstrate the capabilities of ChatGPT. It's essential to thoroughly review and validate any code generated by ChatGPT before using it in your projects. Let's proceed with the tutorial, keeping in mind the limitations and considerations of using AI-generated code. Thanks!
That was a really cool and good one, please make more such advance tutorials
This video is great! Please make some videos like this!
Thanks for this educative tutorial
Thanks for your feedback! Please subscribe to our channel for more tutorials!
Awesome tutorial. That was fun!!!
Thanks for your feedback!
@@thedatalabs Can't wait to see what's next!!!
Awesome
Wow!... Thank you, very much!...
Thanks for your feedback!
Thank you so much. It was very helpful.. I need more
Thanks for your feedback!
Can creat VBA from beginner to advanced
awesome?....I need more
Sure, thanks for your feedback! Please let us know if there are any specific topics you want to cover through Generative AI.
Cool tutorial. Is it possible to have Name with multiple country without duplicating the name?
Can I use Table instead of database sheet grid lines ?
If I have a sharepoint as database, how can I make it as database for my data entry that I created with VBA before?
Hi, can make a guide video to write code by sending email with a button press from form with selecting row?
this is very good information. But you didn't show how to come up with the prompts
how about adding on row 1 column 1 the Actual Date ? every data entry has a date sir
You can modify the prompt and ask to add column for Date as well. Thanks!
Thanks for the video! trying to follow your instructions here.. i will not even go into what GPT is doing when trying to use the same prompts as you, lets just say is a total mess))) the strange part about all of this is that im trying to replicate the results from your video on my own.. i downloaded your file and tried to run the code thats inside step by step on a new file.. the results i get is error on row 17 -- Dim lblEmployeeName As MSForms.Label .. Compile error --- "User-defined type is not defined"... why i see the code working perfectly in the video.. who can explain me whats happening🙄
Слив схем - @sliv_shem5