Load Value into textbox
 

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

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

Load Value into textbox
 

Thanks!
--

Karen


"Bob Phillips" wrote:

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