| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing Cells and Formatting
1.) How do I change the TextBox21 line of code to make it
sum the cells A4, A9, E4, AND E9? Private Sub CommandButton1_click() With UserForm2 .TextBox21.Value = Application.Sum(Cells ("A4", "A9", "E4", "E9")) .Show End With End Sub 2.) For TextBox21, what would the code be to: a. make the value percentage, and b. make the font bold/red when the value is not 100%? Thanks, Phil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing 2 columns cells into a 3rd colums cells | Excel Discussion (Misc queries) | |||
| not summing all the cells | Excel Discussion (Misc queries) | |||
| Summing Cells with #N/A | Excel Worksheet Functions | |||
| Summing of Two cells does not sum!! | Excel Discussion (Misc queries) | |||
| Finding cells and summing variable cells | Excel Programming | |||
Threaded Mode
