Hi,

After working wif Access for so long, I'm trying my hand in Excel now.. HEE

Trying to display a value in a cell, how do i do that using VBA??

Jamie

Hi Jamie,

'display'? Where?



Martin

Displayed in the cell.. but its ok now.. I figured it out anyway.

but i have another tricky problem now. I'm trying to find the compound interest of a principle amount. I've already calculated out the interest rate paid over a few days and I want to add them together.
<font class="small">Code:</font><hr /><pre>
principle = Range("A" & i).Value
interest = Range("B" & i).Value
days = Range("C" & i).Value

For d = 1 To days
val = principle * interest
principle = principle + val
total = total + val
Next d

Range("D" & i).End(xlUp)(2) = total
</pre><hr />

'val' data type is Long and so is 'total'. but when i display total, the value becomes rounded up. Meaning the correct value inside of 'total' should be 78.8125 but when I display in the worksheet, the value has been rounded up to 79.
Even if i format the cells to display decimal places, it still shows 79.000.
any ideas how to fix this?

Jamie

Declare your variables as Double or Currency. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)

Thanks thanks..

But unfortunately it still didn't work.. sighz
Anyways i've solved it logically.

Instead of using a "total" variable to store the accumulated interest, I just stored the accumulated interest in "val" itself. In the end, I managed to get the figures I wanted with all the decimal places..

Jamie