Hi all.

What I need –
A blank option in a data validation dropdown (VBA)

The problem –
I need to provide users a way to mark a record using data validation. But they also need to be able to unmark it (blank option).
Normally I would just tell them to hit “delete” to remove the selection. But since I expect them to run the file in sharepoint, that is not an option apparently.

The file I am creating for the users is created from a larger file, so pointing my data validation list to a range is not an option because that range is not distributed with the final file. So I need to create the data validation string in VBA.

This is the code to create the data validation field without a blank option (preferably first) 
Please Login or Register  to view this content.
This works fine

What I’ve tried -
I tried adding “ – ,”
Please Login or Register  to view this content.
That adds an option “—“ which I don’t want

I tried 
Please Login or Register  to view this content.
I get an error – With Chr highlighted - “Can’t find project or library”

Anyone have any ideas?
Thanks