How to create a Data Entry Application using ChatGPT in MS Excel and VBA

Рет қаралды 19,178

Күн бұрын

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!

Пікірлер: 24

@mkapoor6496 11 ай бұрын

That was a really cool and good one, please make more such advance tutorials

@corralesfidel3913 10 ай бұрын

This video is great! Please make some videos like this!

@ibrahimardoumar9467 Жыл бұрын

Thanks for this educative tutorial

@thedatalabs Жыл бұрын

Thanks for your feedback! Please subscribe to our channel for more tutorials!

@ycpdps Жыл бұрын

Awesome tutorial. That was fun!!!

@thedatalabs Жыл бұрын

Thanks for your feedback!

@ycpdps Жыл бұрын

@@thedatalabs Can't wait to see what's next!!!

@BenDieselBasicAutomotive Жыл бұрын

Wow!... Thank you, very much!...

@thedatalabs Жыл бұрын

Thanks for your feedback!

@somenmondal2964 Жыл бұрын

Thank you so much. It was very helpful.. I need more

@thedatalabs Жыл бұрын

Thanks for your feedback!

@somenmondal2964 Жыл бұрын

Can creat VBA from beginner to advanced

@shashankshekhar7409 Жыл бұрын

Awesome

@BahlulAmin 11 ай бұрын

Can I use Table instead of database sheet grid lines ?

@playmakermc8362 Жыл бұрын

If I have a sharepoint as database, how can I make it as database for my data entry that I created with VBA before?

@CristianoRonaldo-ox7rc 9 ай бұрын

Cool tutorial. Is it possible to have Name with multiple country without duplicating the name?

@leepierre3176 10 ай бұрын

Hi, can make a guide video to write code by sending email with a button press from form with selecting row?

@jmchisanga3 Жыл бұрын

awesome?....I need more

@thedatalabs Жыл бұрын

Sure, thanks for your feedback! Please let us know if there are any specific topics you want to cover through Generative AI.

@oscaroreedaniel3474 9 ай бұрын

this is very good information. But you didn't show how to come up with the prompts

@baifevii 11 ай бұрын

how about adding on row 1 column 1 the Actual Date ? every data entry has a date sir

@thedatalabs 11 ай бұрын

You can modify the prompt and ask to add column for Date as well. Thanks!

@druce8896 8 ай бұрын

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🙄