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