ExcelBanter - How can I ...

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How can I ... (https://www.excelbanter.com/excel-programming/310692-how-can-i.html)

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.

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.

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.

.