| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying text & variable information in cell
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("΄£₯X₯Ξ").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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying text & variable information in cell
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying text & variable information in cell
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$B7n(B1$BF|(B, $B8aA0(B9: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("$BDs=PMQ(B").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.- $B0zMQ%F%-%9%H$rI=<($7$J$$(B - - $B0zMQ%F%-%9%H$rI=<((B - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying text & variable information in cell
If you record a macro formatting a cell to text. That is what it records. "@"
Try 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.- εΌη¨γγ*γΉγγ葨瀺γγͺγ - - εΌη¨γγ*γΉγγ葨瀺 - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying text & variable information in cell
I know how to record a macro, but don't know how to record one
formatting a cell to text. What would I type in the cell when the macro is recording? --- MIKE WROTE --- If you record a macro formatting a cell to text. That is what it records. "@" Try it. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying text & variable information in cell
Just right-click on a cell. Select Format Cells... Select Text as the format.
Thats it. "pallaver" wrote: I know how to record a macro, but don't know how to record one formatting a cell to text. What would I type in the cell when the macro is recording? --- MIKE WROTE --- If you record a macro formatting a cell to text. That is what it records. "@" Try it. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying text & variable information in cell
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.- εΌη¨γγ*γΉγγ葨瀺γγͺγ - - εΌη¨γγ*γΉγγ葨瀺 - |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.- εΌη¨γγ*γΉγγ葨瀺γγͺγ - - εΌη¨γγ*γΉγγ葨瀺 - |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying text & variable information in cell
Nope, sorry Rick. That doesn't work. I get an error. I tried adding
parenthesis around the variables as well, but similar to above, NG. I'm stuck on my macro now on some execution error 13, non-agreement with bodies.... argh... On 7$B7n(B1$BF|(B, $B8a8e(B12:53, "Rick Rothstein \(MVP - VB\)" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| displaying text in a cell if a another cell falls in a range | Excel Worksheet Functions | |||
| Full text in a cell is not displaying or wrapping | Excel Discussion (Misc queries) | |||
| Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
| Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
| Text not all displaying in a cell, what is max that can be inserted? | Excel Worksheet Functions | |||
Hybrid Mode
