displaying text & variable information in cell
In looking at the code line, I don't see why the Format function call is
needed at all... it looks like a simple concatenation and cell assignment to
me.
To the OP.... does this modified statement work also?
Sheets("???").Cells(SokuteiItemRow, SokuteiItemColumn + 2).Value = _
"+" & XPosVariance & "/-" & XNegVariance
Rick
"Mike" wrote in message
...
And yes it will work with out it.
"pallaver" wrote:
BAM! On the money.
Sorry for the ???, I'm working on macros in Japan, thus have sheet
names in Japanese which probably don't convert. This site is a
lifesaver since it's really hard to figure out the help function
entirely in Japanese.
One question though, why is "@" necessary at the end? I wonder if it
works without it.
Thanks.
On 7月1日, 午前9:34, Mike wrote:
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.- 引用テ*ストを表示しない -
- 引用テ*ストを表示 -
|