| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Check Box
I have cell I13 which calculates the tax amount of an item. I have now set up
a check box, when it is clicked it will display a user form asking to user to enter an alternative tax amount and press €œOK€ button. I have linked the €œOk€ buttons result to O13. How do I write the code if I want the O13 result to overwrite I13 only if it is checked and if it is not checked €“ I13 calculation will remain? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Check Box
Hi,
You didn't show us any of your code but Private Sub btnOK_Click() If Me.chkCondition = True Then [I13]=[O13] End If End Sub I am assuming your checkbox is named chkCondition If this helps, please click the Yes button. Cheers, Shane Devenshire "Kaey" wrote: I have cell I13 which calculates the tax amount of an item. I have now set up a check box, when it is clicked it will display a user form asking to user to enter an alternative tax amount and press €œOK€ button. I have linked the €œOk€ buttons result to O13. How do I write the code if I want the O13 result to overwrite I13 only if it is checked and if it is not checked €“ I13 calculation will remain? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| ... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
Linear Mode
