Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I ...
Hi,
I'm working with VB. How can I do the following with VB commands: 1. Declare K (variable) as a regular number 2. Declare K as percentage variable 3. (Variable) K = Current Cell 4. Current Cell = (Variable) K Thank you, Haim. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I ...
Haim,
Try ... 1. Dim K as Double '(Double-precision floating point) 2. As above. Calculate your percentages as decimals and format the output cell in your spreadsheet as percentage 3. K = activecell.value 4. activecell.value = K I hope that this helps "Haim" wrote: Hi, I'm working with VB. How can I do the following with VB commands: 1. Declare K (variable) as a regular number 2. Declare K as percentage variable 3. (Variable) K = Current Cell 4. Current Cell = (Variable) K Thank you, Haim. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I ...
Thank you, dowensan. This help me a lot. Thanks, Haim. -----Original Message----- Haim, Try ... 1. Dim K as Double '(Double-precision floating point) 2. As above. Calculate your percentages as decimals and format the output cell in your spreadsheet as percentage 3. K = activecell.value 4. activecell.value = K I hope that this helps "Haim" wrote: Hi, I'm working with VB. How can I do the following with VB commands: 1. Declare K (variable) as a regular number 2. Declare K as percentage variable 3. (Variable) K = Current Cell 4. Current Cell = (Variable) K Thank you, Haim. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|