Using a Defined Name in VBA

[ChemistB]

I have a single cell in Worksheet "instructor" defined as "WrongAnswer" with Workbook Scope. I am using this code assigned to a User form

Please Login or Register  to view this content.

Works fine until I add WrongAnswer. Do I need to define the variable in VBA (if so, what as, Long?) or include the worksheet name ie. sheets("instructor").range("WrongAnswer").Value

I tried several options but it's not picking up the defined name. Thanks

[MickG]

Try this:-

Please Login or Register  to view this content.

[Norie]

Try either Sheets("Instructor").Range("WrongAnswer").Value, Range("WrongAnswer").Value or [WrongAnswer].

[ChemistB]

Perfect Mick. Thanks!

[MickG]

Your welcome
Regrds Mick