VBA Excel - Budget - Expenses Calculator - VBA Excel Project Part 2

preview_player
Показать описание
VBA Excel - Budget - This is a great little project that you can use to cut your teeth on the VBA editor and creating user forms. I'll show you how to move the data from the user form to a database sheet with ease. VBA Excel tutorial. Here are some of the things you will learn in addition to this.VBA Excel information.
What you will learn?
Dynamic named ranges
Visual basic editor
Userforms and properties
Recording macros
Pivot tables
Pivot charts
VBA Excel expenses tracker. Excel 2010 tutorial.
Рекомендации по теме
Комментарии
Автор

Hi Trevor, I am working with Excel 2013. I managed to build the user form but could not save it.

TheMassa
Автор

Hi Trevor, Thank you for this series. Which key did you click at 10.10 to open the module?

TheMassa
Автор

after clicking on userform without choosing any store, category or take any amount, then i click on add data its adding to the database with date only , im just looking for the code that doesnt allow add to the data base without fill the store, category, amout, just tell me pls

km
Автор

I changed it to userform "DataEntry"
Sub DataForm()
DataEntry.Show
End Sub
but the error still occurred: Run-time Error '424': Object Required

quocvietho
Автор

why does error occur?? "dataentry.show" not recognize

nerisalagrimas