Load Value into textbox

[Guest]

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

 

[Bob Phillips]

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

--
---
HTH

Bob

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

 

[Guest]

Thanks!
--

Karen

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

--
---
HTH

Bob

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