Remember Me?

#1
November 29th 04, 11:39 PM
 DaveSunsation Posts: n/a
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
November 29th 04, 11:45 PM
 DaveSunsation Posts: n/a

=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
December 1st 04, 05:02 AM
 Charles Maxson Posts: n/a

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post marika1981 Excel Discussion (Misc queries) 14 January 14th 05 11:47 PM [email protected] New Users to Excel 2 January 6th 05 08:18 AM Rich New Users to Excel 2 December 9th 04 03:06 AM Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM

All times are GMT +1. The time now is 06:36 PM.