Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-30-2018, 03:43 PM
RAH RAH is offline One Cell that controlls spread sheet result button to change simple fomula result Windows 10 One Cell that controlls spread sheet result button to change simple fomula result Office 2016
Advanced Beginner
One Cell that controlls spread sheet result button to change simple fomula result
 
Join Date: Jun 2016
Posts: 31
RAH is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 03-30-2018, 11:49 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline One Cell that controlls spread sheet result button to change simple fomula result Windows 7 64bit One Cell that controlls spread sheet result button to change simple fomula result Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 03-31-2018, 02:41 AM
RAH RAH is offline One Cell that controlls spread sheet result button to change simple fomula result Windows 10 One Cell that controlls spread sheet result button to change simple fomula result Office 2016
Advanced Beginner
One Cell that controlls spread sheet result button to change simple fomula result
 
Join Date: Jun 2016
Posts: 31
RAH is on a distinguished road
Default

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.
Attached Files
File Type: xlsm BUTTON DIVISION.xlsm (20.0 KB, 14 views)
Reply With Quote
  #4  
Old 03-31-2018, 07:09 AM
NoSparks NoSparks is offline One Cell that controlls spread sheet result button to change simple fomula result Windows 7 64bit One Cell that controlls spread sheet result button to change simple fomula result Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

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
Reply With Quote
  #5  
Old 03-31-2018, 09:18 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline One Cell that controlls spread sheet result button to change simple fomula result Windows 7 64bit One Cell that controlls spread sheet result button to change simple fomula result Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #6  
Old 03-31-2018, 04:52 PM
RAH RAH is offline One Cell that controlls spread sheet result button to change simple fomula result Windows 10 One Cell that controlls spread sheet result button to change simple fomula result Office 2016
Advanced Beginner
One Cell that controlls spread sheet result button to change simple fomula result
 
Join Date: Jun 2016
Posts: 31
RAH is on a distinguished road
Default

Thank you very much for taking the time to solve this for me it works a treat
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
One Cell that controlls spread sheet result button to change simple fomula result How to change the formula to get this result .... LearnerExcel Excel Programming 2 02-11-2018 08:26 PM
One Cell that controlls spread sheet result button to change simple fomula result Formula result not displaying in cell (but f9 works) nath1235 Excel 4 10-06-2017 12:42 PM
One Cell that controlls spread sheet result button to change simple fomula result How To Move Focus From VLOOKUP Result to Report Sheet swindon.expat Excel 2 04-10-2016 12:15 AM
One Cell that controlls spread sheet result button to change simple fomula result Simple Spread Sheet TThomas Excel 1 04-07-2016 09:01 PM
One Cell that controlls spread sheet result button to change simple fomula result Show result of formula as a value in another cell Steve_D Excel 4 10-12-2014 07:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft