Chat GPT in Excel VBA: Create the Data Entry form with AI
Vložit
- čas přidán 17. 06. 2023
- #ChatGPT #ExcelVBA #UserForm
Hello Friends,
In this video, we'll walk you through the process of creating a user-friendly Data Entry form in Excel VBA, powered by OpenAI's Chat GPT. From setting up worksheets to generating VBA codes with AI, our guide makes it easy for you to automate your spreadsheet tasks. Harness the power of AI and elevate your Excel skills with us today!
Download the practice file below link:
www.pk-anexcelexpert.com/chat...
Watch the Step-by-Step Tutorial for Project Plan (Gantt Chart) in Excel
• Project Plan(Gantt Cha...
Learn the more than 100 Excel formulas
www.pk-anexcelexpert.com/form...
Use of Symbols and Emojis in Excel Drop-down List and Excel Charts
• Use of Symbols and Emo...
Learn Step by Step Pivot table:
www.pk-anexcelexpert.com/pivo...
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
See our Power BI Dashboard videos:
• Power BI Tutorial
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Calendar Control in VBA from below link
www.pk-anexcelexpert.com/full...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/pks-...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Twitter:
/ priyendra_kumar
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...
That was truely awesome ♥️
Thanks🙏
That's great Video, PK keep it up.
Thanks🙏
Ur genius bro , keep up 💪💪
Thanks🙏
Love from Pakistan.
Thanks🙏
sir simple question you have said range a1 name, a2 age , a3 salary, a4 department. but actually b1 is age, c1 is salary and d1 is department.
Thanks bro, how about Cancel button.
Hey Can you pls share the VBA Code That was generated.
As a start of the video u said no prior knowledge of VBA but after looking this video there should be knowledge of VBA..so that person can do the needful.
Because to write the rough code in notepad and pasting this in chatgpt there should be knowledge of VBA n chatgpt AI can easily understand what users want basically.
Overall thanks for the video 🙂
Sorry for that, you need to have the basic knowledge of VBA.
@@PKAnExcelExpert exactly and i understood.
Thanks 🙏👍
@@prabhakarpandey5133
If you have interest and watch 15-20 vba videos of PK you will easily get vba basic knowledge
whats the "setting" for.?
Sir please make a video on Data Visualization in using pivot table in VBA Project with chat gpt
Sure. will try...
There is a Form for input data already built into Excel.
hello the button cancel doesn't work .
HI EXPERT I WANT BANK STATEMENTS TO EXCEL HOW TO IDENTIFY FOR EMPOLY UTR NUMBER AND IF ANY RETURNS AND HOW MANY TIME WILL PAY FOR THIS BANK ACCOUNT NUMBER SO PLEASE EXPLAIN SIR IM ALREDY TRY TO TEXT TO COLUM SPLIT DATA SIR PLEASE HELP MEE
chatgpt can only make easy code. It gave me errorous code many times when asking for complicated stuff.
Hey Can you pls share the VBA Code That was generated.