Maybe this
Sheets("???").Cells(SokuteiItemRow, SokuteiItemColumn + 2).Value = _
Format("+" & (XPosVariance) & "/-" & (XNegVariance), "@")

"pallaver" wrote:

I have two variables taken from textboxes on a userform: XPosVariance
& XNegVariance

I want to have them displayed in a cell when clicking done on the
userform such that the cell reads:

+5/-8

(In the case that XPosVariance = 5 and XNegVariance = 8).

I have this:

Sheets("提出用").Cells(SokuteiItemRow, SokuteiItemColumn + 2).Value = "+"
& (XPosVariance) & "/-" (XNegVariance)

But it doesn't work. I'm sure the variables are fine because as a
test I just wrote = "TEST" and I get "TEST" written in the correct
spot. Any way I can do the above? I have a feeling this isn't a
tough question, I just don't know how to do it.

Thankx.