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

Form

0

I'm building the form from the YouTube videos "adding data"

when I try to run it I get a error msg

run time error"9"

script out of range

the VBA code is per video

Set data_Sheet = Sheets("Data")

any ideas?

I've re-watched the video several times thinking I simple wrote it wrong or missed something 

Answer
Discuss

Answers

0

Does the file that you are working in have a Sheet named "DATA"??  Probably not....and that is what the error is.   Either change the name of your sheet tot "DATA" OR change the name of the sheet within the quotes to one of your sheet names (in the Set  data_Sheet line you presented above)/

Discuss


Answer the Question

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