Run-time error 1004: application-defined or object-defined error

[JM_000888]

I'm trying to create a toggle button that, when selected, runs some code to create a dropdown list with two possible options, and when de-selected clears the cell.

Apparently there's a problem with a section of the code, but I don't know what it is:

I get the error message in the title.

Any idead why?

 

[Skyybot]

If you use the xlBetween operator you are required to have two arguments. It has to be "between" something, so you need a Formula1 and Formula2

 

[JM_000888]

Huh, well thank you. What should Formula2 be then, do you think?
The way I got the code was that I recorded a Macro of myself creating the dropdown manually, then went back and looked at it and re-used it. So whatever I did when I did it that way, that's the code I'm using.

 

[Skyybot]

Hard to say without seeing your file and knowing exactly what you're thinking when you perform the macro record but maybe

Formula1:= Range("K100").Value, Formula2:= Range("K101").Value

 

[JM_000888]

Okay, those two cells (K100 and K101) are just the cells in the sheet where I'm storing the text for the two dropdown options the user could potentially pick (the "reference" for the list, I guess). But it seems like right now they are written in the code as sort of "one" item? Maybe by splitting them up into two separate items it will work? I will try it, thanks.

 

[JM_000888]

Alright, I tried it and got the same error message:

 

[Skyybot]

Or you could try removing the Between operator

 

[Skyybot]

Also, it would really help if you posted your code with text and code tags instead of a picture

 

[MARK858]

Should be

xlValidAlertStop

not

xlValidateAlertStop

in the original code

 

[JM_000888]

Did I take out too much stuff? It doesn't seem to like that either.