| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Load ws cell data into a textbox via click on chart datapoint | Charts and Charting in Excel | |||
| Storing TextBox info in cells, then retrieving on next load-up | Excel Programming | |||
| Storing TextBox info in cells, then retrieving on next load-up | Excel Programming | |||
| HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
| Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
Linear Mode
