Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using a button in a cell
I have a costing spreadsheet that uses a formula that times one cell and puts
it in a total cell - I'd like to incorporate a button rather than having them have to enter a 1 in a cell. Any help would be greatly appreciated. |
#2
|
|||
|
|||
=SUM(G9)*H9 is a typical formula that requires the input of a value - cell h9
I'd like to have a button clickable that if clicked would equal 1 and the default would always equal 0 zero "DaveSunsation" wrote: I have a costing spreadsheet that uses a formula that times one cell and puts it in a total cell - I'd like to incorporate a button rather than having them have to enter a 1 in a cell. Any help would be greatly appreciated. |
#3
|
|||
|
|||
Davem
Have you thought about a checkbox? If I understand your post, I think a checkbox linked to the cell would work here... let me know. -- Charles www.officezealot.com "DaveSunsation" wrote in message ... =SUM(G9)*H9 is a typical formula that requires the input of a value - cell h9 I'd like to have a button clickable that if clicked would equal 1 and the default would always equal 0 zero "DaveSunsation" wrote: I have a costing spreadsheet that uses a formula that times one cell and puts it in a total cell - I'd like to incorporate a button rather than having them have to enter a 1 in a cell. Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |