Load Value into textbox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karen53 - 27 Sep 2007 21:34 GMT

Hi,

I'm trying to load a value from my sheet into a textbox but multiplied by
100 so the percentage has the correct decimal place. I am having trouble
getting it to work.

Me.txtRentalTax.Value = .Cells(Choice, 8).Value * 100
Me.txtGrossUp.Value = .Cells(Choice, 9).Value * 100

Thanks

Signature

Karen

Reply to this Message

Bob Phillips - 27 Sep 2007 22:15 GMT

Me.txtRentalTax.Value = Format(.Cells(Choice, 8).Value , "0.00%")

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Karen53 - 27 Sep 2007 23:16 GMT

Thanks!

Signature

Karen

> Me.txtRentalTax.Value = Format(.Cells(Choice, 8).Value , "0.00%")
>
[quoted text clipped - 8 lines]
> >
> > Thanks

Reply to this Message