Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Run-Time Error 1004, Application or object defined, Module 2 for Save data from form.

0

I've created my form and gone through all the videos.  Very helpful thank you.  Just tested module 2 from Video 5 - Save Data from Form and I'm getting a run-time error.  The debug stops on the nextRow = line.  I copied from the tutorial exactly and I've reviewed data.  I can't find the problem...

Help please.

Paige

excel
MS Office Version: Office 365
posted by: Paige on Wed Sep 25, 2019 at 1:16 pm
Answer
Discuss

Discussion

What video? What is the link? Where is you code or file with code?

Sounds like you missed setting a reference in Tools > References.
KenHobson (rep: 55) Sep 25, '19 at 2:43 pm
To help you find your bearings here: Don is the one who wrote all the tutorials. He would probably know what you are talking about. Almost everybody else knows a little or much about Excel but is unlikely to know the tutorials. The best way to get an answer to your question is to post your code and presume that people here know only what you tell them.
Variatus (rep: 4889) Sep 27, '19 at 5:44 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login