How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 1997
Experience:  Extensive Knowledge in PHP, MYSQL, CSS & Javascript
62934938
Type Your Programming Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

I new to this type of coding, and need help. I will share

Customer Question

Hi I new to this type of coding, and need help. I will share what I am trying to do, can you help.
Sub Balance()
'Go to Consolidated Worksheet
Worksheets("Consolidated").Activate
'Select Cell v92 in Consolidated Worksheet
Range("v92").Select
'Enter this cell with numbers as a percent to bring cell v93 to $0.00
Dim v92 As Action
'This cell needs to meet the condition of $0.00
Dim v93 As Double
Do Until v93.Value = 0
v92 = v92 + 0.1
Loop Until (v93 = 0)
'Display message box on screen indicating cell v93 equals $0.00
MsgBox "Balanced"
End Sub
Submitted: 1 year ago.
Category: Programming
Expert:  The-PC-Guy replied 1 year ago.

can you send your sheet and provide a description of what you are trying to accomplish.

Customer: replied 1 year ago.
I gave you the macro that I started. I want a loop code to automatically enter a cell percent value until another cell equals zero. I thought my macro explained. Sorry
Customer: replied 1 year ago.
Sub Balance()
'Go to Consolidated Worksheet
Worksheets("Consolidated").Activate
'Select Cell v92 in Consolidated Worksheet
Range("v92").Select
'Automatically enter this cell with numbers (-200.00% to +200.00%)as a percent to bring cell v93 to $0.00
Dim v92 As Action
'This cell needs to meet the condition of $0.00
Dim v93 As Double
Do Until v93.Value = 0
v92 = v92 + 0.1
Loop Until (v93 = 0)
'Display message box on screen indicating cell v93 equals $0.00
MsgBox "Balanced"End Sub
Customer: replied 1 year ago.
I need help from Dim to Loop portion of the macro. Tried sending file but failed
Expert:  The-PC-Guy replied 1 year ago.

you can try a 3rd party site like

www.wikisend.com

after uploading they give you a file ID#

paste it here.

i will really need to see how the dat ais arranged to be able to help you.

Customer: replied 1 year ago.
K will try later today
Expert:  The-PC-Guy replied 1 year ago.

okey

Customer: replied 1 year ago.
Hi, sorry for the delay, the weekend got in the way. You can create your own worksheet from this information to assist you:cell a1 = any value, but we will use 50,000
Cell a2 = any value, but we will use 48,000
Cell b1 = the input cell formatted as a percent.
cell b2 = this formula (a1-a2)I want the computer to automatically enter a percent value (increments of .10) in cell b1 until the value in cell b2 = 0, then stop. That simple.
I see my credit card has been charged $32.00.
Expert:  The-PC-Guy replied 1 year ago.

sorry, I am not responsible for the way they do the billing.

following your example, I am not sure how cell b1 would influence any of the other cells. If B2 is A1 - A2. What is cell b1 supposed to represent,

How would altering the B1 cell effect the B2 cell value if it is not used in any formulas?

Customer: replied 1 year ago.
Go to wikisend File #209122Cell v92 Hope this helps.
Expert:  The-PC-Guy replied 1 year ago.

i have the sheet, but it doesn't help me see the big picture of what you want to acomplish? What does cell v92 represent what is your goal?

Customer: replied 1 year ago.
Enter 0 in cell v92 and v93 goes to 121000I want the computer to enter v92 until v93 is o
The range can be -200 to 200
Customer: replied 1 year ago.
I want to click that balance button and the cell goes to 0 by entering values in v92
Expert:  The-PC-Guy replied 1 year ago.

lets try this a different way, the only way v93 is 0 is if both u92 and u93 are the same.

Expert:  The-PC-Guy replied 1 year ago.

since the value of u93 is not changing wouldn't it always be whatever u92 value is to make v93 = 0

Customer: replied 1 year ago.
U92 changes when you enter values. Look at the formula in u92. U93 is static
Expert:  The-PC-Guy replied 1 year ago.

the value that is in u92 is the value you are trying to get correct?

Customer: replied 1 year ago.
No I want value in v93 to be at zero by having computer enter values in v92 or have computer enter values in v92 u til v93 is 0
Expert:  The-PC-Guy replied 1 year ago.

i could create a macro that did it,

but you may want to check out one of excels built in tools first.

It is called Goal Seek and does exactly what you want.

You may have to install the analysis toolpack add in and solver add ins before you can find it on the menu.

here is more information on it.

https://support.office.com/en-us/article/Use-Goal-Seek-to-find-a-result-by-adjusting-an-input-value-ef3495fe-9ddc-4249-89b4-0e24406b7fcb

let me know if this helped you or not.

Customer: replied 1 year ago.
That's ok. I'll just enter manually. Please credit my account back 32.00. Thank you
Expert:  The-PC-Guy replied 1 year ago.

so you don't want my help?

Customer: replied 1 year ago.
No I want help but I want specific to my problem. Just credit my mc account. Thanks for your time