Changing spinner value if greater than

jackylegs222

New Member
Joined
Apr 29, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. MacOS
Hi, I've been having a lot of trouble trying to work out a way to get this to all work very smooth but I have been having trouble getting it smoothed out.

I have everything work how I want to the point that I have the Player attributes to go change up/down by one when any of the spinners are clicked, which is what I want to do but I want it to do a little more.
Example of what I want: When you are adding to any attribute, once said attribute reaches 75-80 I want it to cost 2 points but still increment up by one. The same at 81-85 but I want the cost to be 3

When D38+1 between >=80, I want G34-1.
When D38+1 between <81but =>85, I want G34-2 and so on.

Also, if there is a way I can stop the Player Attributes going into minus and have it block the up arrow at G34=0 somehow that would be amazing
 

Attachments

  • Screen Shot 2020-04-29 at 1.49.46 PM.png
    Screen Shot 2020-04-29 at 1.49.46 PM.png
    202.9 KB · Views: 6

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Essentially, I want Attribute points change when spinner is used.
If numbers are below 80 I want 1 attribute point to cost 1point
If numbers are between 80-85 I want 1 Attribute to cost 2 points
If numbers are between 85-90 I want 1 Attribute to cost 3 points
If numbers are between 90-95 I want 1 Attribute to cost 4 points
If numbers are between 95-99 I want 1 Attribute to cost 5 points
Is there any way to function this in with Spinners?
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,636
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top