Command Box can't pick up variable from cell value

[melodramatic]

First time I've seen this problem.

I'm using an ActiveX CommandBox, and in it, have set up a variable that is the value of a cell.

Dim TXHBox As String
Dim EndRow As Long

TXHBox = Range("C2")
EndRow = Range("D2") + 7

Cell C2 is a calculated alpha-numeric code.
Cell D2 is a calculated numeric count.

For some reason, those variables won't pick up. I've created a MsgBox to let me know what it's picked up as the variables, and in both cases, it's blank.

But, I copied the entire coding from the CommandBox to a Macro, and it worked with no problem.

Is there a different way to look this up in Command Box? Or am I limited to picking up variables from cells in macros?

Thanks for your help!

 

[mikerickson]

There is a Command BUTTON and a Combo BOX, which of those are you dealing with?

And its not clear what you are trying to do.