Hi Everyone,

I'm wondering if the following is possible in VBA. In some code I'm making, I'm creating a flag variable.
You know how if a variable is declared as a boolean, and you put VariableName= a little box comes up giving you the choices of true and false? Is that possible for a custom format? I have a variable in my code called SurroundCell that I'd like to have only three choices available for it (vNoSurround, vSurroundAll, vSurroundDelim). Currently I'm using this code:

Dim vNoSurround As Integer, vSurroundAll As Integer, vSurroundDelim As Integer
 Dim SurroundCell As Integer
 vNoSurround = 0: vSurroundAll = 1: vSurroundDelim = 2
 SurroundCell = vNoSurround
which works for what I need, but I'd rather it offer me the three choices when I type SurroundCell=

Is this possible? If it is, is it too much work to accomplish? It's not really necessary for me, just something I thought would be nice.

Thanks!
Matt