View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_801_] Rick Rothstein \(MVP - VB\)[_801_] is offline
external usenet poster
 
Posts: 1
Default 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.- 引用テ*ストを表示しない -

- 引用テ*ストを表示 -