|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
One Cell that controlls spread sheet result button to change simple fomula result
Hello I have a spread sheet with one cell that controls the final result. It is a simple equation but has a big spread sheet with a lot of equations tied to it the master question being =D7/2 How would I create a button that would t give me the result on the same spread sheet =D7/3 am I looking at it in the wrong way as I cannot think my way around it thanking you in advance. |
#2
|
||||
|
||||
Could you please be a little more explicit and eventually post a small sample sheet describing your needs?
Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thanks for your reply I have attached what I think may be the requirement for this to work however you may see it a different way.
|
#4
|
|||
|
|||
If you need to change button color use ActiveX buttons,
and what you indicate can be done with just one button. Code:
Private Sub CommandButton3_Click() ' use of only one ActiveX button With CommandButton3 If .BackColor = vbYellow Then Range("A4").Formula = "=A2/2" .Caption = "Current division is by 2" .BackColor = vbCyan Else Range("A4").Formula = "=A2/3" .Caption = "Current division is by 3" .BackColor = vbYellow End If End With End Sub |
#5
|
||||
|
||||
Moved to the programming forum
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
|||
|
|||
Thank you very much for taking the time to solve this for me it works a treat
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to change the formula to get this result .... | LearnerExcel | Excel Programming | 2 | 02-11-2018 08:26 PM |
Formula result not displaying in cell (but f9 works) | nath1235 | Excel | 4 | 10-06-2017 12:42 PM |
How To Move Focus From VLOOKUP Result to Report Sheet | swindon.expat | Excel | 2 | 04-10-2016 12:15 AM |
Simple Spread Sheet | TThomas | Excel | 1 | 04-07-2016 09:01 PM |
Show result of formula as a value in another cell | Steve_D | Excel | 4 | 10-12-2014 07:38 PM |