Data Validation VBA Input Message

[default_name]

Hello,

I have a large batch of data.
There are 5 different types of data. Every 5 rows, there is a new set of data.
I am trying to implement Data Validation Input Messages so that when a user is on a certain cell, they will know what type of data is being referenced.
Not sure if that makes sense....i'll try to illustrate:

​ A​ B​ C​ D​ E​ F​ . . .​ AS​ 1​ TypeA​ 55​ 12​ 16​ 9​ 5​ . . .​ 37​ 2​ TypeB​ 57​ 73​ 82​ 99​ 21​ . . .​ 0​ 3​ TypeC​ 0​ 0​ 4​ 18​ 6​ . . .​ 8​ 4​ TypeD​ 9​ 9​ 5​ 25​ 4​ . . .​ 66​ 5​ TypeE​ 1​ 1​ 38​ 7​ 0​ . . .​ 5​ 6​ TypeA​ 8​ 4​ 42​ 71​ 22​ . . .​ 15​ 7​ TypeB​ 65​ 8​ 31​ 5​ 79​ . . .​ 0​ 8​ TypeC​ 455​ 26​ 31​ 30​ 15​ . . .​ 43​ 9​ TypeD​ 98​ 99​ 2​ 0​ 3​ . . .​ 13​ 10​ TypeE​ 5​ 6​ 5​ 1​ 2​ . . .​ 18​ . . .​ . . .​ . . .​ . . .​ . . .​ . . .​ . . .​ ​ . . .​ 2005​ TypeE​ 66​ 8​ 32​ 6​ 4​ . . .​ 52​

<--This is similar to what my data looks like. Let's say that I happen to have cell F7 selected. The data validation message would appear saying "TypeB" (since F7 is in the TypeB row). [Is there a way to have the message reference the data type from column A?] I want this little note box to appear because as you get further to the right (let's say cell AS4) in order to see what type the item is (TypeD in this example for AS4), the user would have to scroll all the way back over to the left. I know this can also be done by freezing the first column pane...but I don't want to use this method. This type of data continues to the bottom of the table (which occaisonally grows longer) [in this example there are currently 2005 rows]. The TypeA, TypeB....pattern continues every 5 rows until the bottom of the table. Is there a way to assign this data validation pattern to all the rows to the end of the table (B1:AS2005 in this example)?

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.