Load Value into textbox
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)
"Karen53" wrote in message
...
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
--
Karen
|