Hi, I am trying to figure out how to change a value in a cell using VBA in Excel...this would occur within the cell itself...if the value is >= 0.95, I want to divide the value by 1,000, if >= .095 and < .95, I want to divide the value by 100, and if >= .0095 and < .095, I want to divide by 10. Is this possible?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Change a cell based on the value that I enter
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,971
- Office Version
- 365
- Platform
- Windows
The question is, when do you want this to run? What is going to call this macro to run?
Do you want to run it automatically as they enter data in, or are you running it against an already populated sheet?
What is the range that you want to run this against?
Do you want to run it automatically as they enter data in, or are you running it against an already populated sheet?
What is the range that you want to run this against?
Upvote
0
Similar threads
- Solved
- Question
