How to add data to macro versus referencing cells - validate list

[288enzo]

My original macro is working fine using the following

    Range("C1").Validation.Add Type:=xlValidateList, Formula1:="=Subjects!$A$1:$A$5"

What I would prefer is to have the data in Subjects!$A$1:$A$5 to be hard coded into the macro and not have to reference the previously mentioned. Is this possible?

The following is what is in A1:A5 and the line above will create a drop down menu based on the below.

Friday Before

1 Hour Email

Class Has Started

Removed

In-Person

I hope that's clear , or clear as mud?

Thank you,

 

[rlv01]

One way.

ValidationList = "Friday Before,1 Hour Email,Class Has Started,Removed,In-Person"
Range("C1").Validation.Add Type:=xlValidateList, Formula1:=ValidationList

Where ValidationList is a string variable.

 

[288enzo]

One way.

ValidationList = "Friday Before,1 Hour Email,Class Has Started,Removed,In-Person"
Range("C1").Validation.Add Type:=xlValidateList, Formula1:=ValidationList

Where ValidationList is a string variable.

That's fantastic, thank you for the assist.