Writing to cell D27 is not updating to a value [on hold] The 2019 Stack Overflow Developer...
What does "rabbited" mean/imply in this sentence?
Should I write numbers in words or as numerals when there are multiple next to each other?
Is there a name of the flying bionic bird?
Output the Arecibo Message
Should I use my personal or workplace e-mail when registering to external websites for work purpose?
What is the best strategy for white in this position?
What is the steepest angle that a canal can be traversable without locks?
Is "plugging out" electronic devices an American expression?
Is three citations per paragraph excessive for undergraduate research paper?
Is it possible for the two major parties in the UK to form a coalition with each other instead of a much smaller party?
Understanding the implication of what "well-defined" means for the operation in quotient group
Which Sci-Fi work first showed weapon of galactic-scale mass destruction?
What is the motivation for a law requiring 2 parties to consent for recording a conversation
Unbreakable Formation vs. Cry of the Carnarium
Spanish for "widget"
Could JWST stay at L2 "forever"?
Monty Hall variation
How to manage monthly salary
Why is it "Tumoren" and not "Tumore"?
What is this 4-propeller plane?
What does "sndry explns" mean in one of the Hitchhiker's guide books?
Does duplicating a spell with Wish count as casting that spell?
Why do UK politicians seemingly ignore opinion polls on Brexit?
On the insanity of kings as an argument against Monarchy
Writing to cell D27 is not updating to a value [on hold]
The 2019 Stack Overflow Developer Survey Results Are InCleaning up and reformatting imported data in an Excel sheetStandard Methods in VBAAggregating data from multiple worksheets into a consistent formatInterpolating data of multiple trainsEliminating empty spreadsheet cells from a rangeMaking a report from payroll detailsMirror and update cells across tabs and formsClass to update a userform with an external workbook and vice versaChecking cell-by-cell, updating several workbooksHow to return cell values of a non-sequential set of cells from multiple closed spreadsheets? Code condensing/simplification
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
$begingroup$
I am reading in the inputs from cell D24 and E24, then attempting to update cell D27, based off of the input I make in cell E24(1, 2, neither). Why is my code compiling correctly, but not outputting the correct value? I completed a debug and my "z" variable has the correct value, but it's not writing the value to the cell.
Sub UpdateD_27()
Dim x As Integer 'Declare variable for Starting Value
Dim y As Integer 'Declare variable for Choice/Editable Value
Dim z As Integer 'Declare variable for Answer
Dim m As String 'Declare variable for Message to User
x = ActiveWorkbook.Sheets("TabF").Range("D24").Value 'Set variable in memory storage location
y = ActiveWorkbook.Sheets("TabF").Range("E24").Value 'Set variable in memory storage location
z = ActiveWorkbook.Sheets("TabF").Range("D28").Value 'Set variable in memory storage location
If (y = 1) Then
z = x * 7
ElseIf (y = 2) Then
z = x / 7
Else
m = "Please enter the value 1 or 2 in cell E24."
End If
End Sub
vba excel
asked 4 hours ago
Tanner10Tanner10
1
New contributor
Tanner10 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
put on hold as off-topic by AJNeufeld, Sᴀᴍ Onᴇᴌᴀ, 200_success, pacmaninbw, esote 3 hours ago
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Code not implemented or not working as intended: Code Review is a community where programmers peer-review your working code to address issues such as security, maintainability, performance, and scalability. We require that the code be working correctly, to the best of the author's knowledge, before proceeding with a review." – AJNeufeld, Sᴀᴍ Onᴇᴌᴀ, 200_success, pacmaninbw, esote
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
$begingroup$
I am reading in the inputs from cell D24 and E24, then attempting to update cell D27, based off of the input I make in cell E24(1, 2, neither). Why is my code compiling correctly, but not outputting the correct value? I completed a debug and my "z" variable has the correct value, but it's not writing the value to the cell.
Sub UpdateD_27()
Dim x As Integer 'Declare variable for Starting Value
Dim y As Integer 'Declare variable for Choice/Editable Value
Dim z As Integer 'Declare variable for Answer
Dim m As String 'Declare variable for Message to User
x = ActiveWorkbook.Sheets("TabF").Range("D24").Value 'Set variable in memory storage location
y = ActiveWorkbook.Sheets("TabF").Range("E24").Value 'Set variable in memory storage location
z = ActiveWorkbook.Sheets("TabF").Range("D28").Value 'Set variable in memory storage location
If (y = 1) Then
z = x * 7
ElseIf (y = 2) Then
z = x / 7
Else
m = "Please enter the value 1 or 2 in cell E24."
End If
End Sub
vba excel
asked 4 hours ago
Tanner10Tanner10
1
New contributor
Tanner10 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
put on hold as off-topic by AJNeufeld, Sᴀᴍ Onᴇᴌᴀ, 200_success, pacmaninbw, esote 3 hours ago
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Code not implemented or not working as intended: Code Review is a community where programmers peer-review your working code to address issues such as security, maintainability, performance, and scalability. We require that the code be working correctly, to the best of the author's knowledge, before proceeding with a review." – AJNeufeld, Sᴀᴍ Onᴇᴌᴀ, 200_success, pacmaninbw, esote
If this question can be reworded to fit the rules in the help center, please edit the question.
1
$begingroup$
CodeReview is about already working code and has the requirement must contain code that is already working correctly. We can review your code once it's working correctly. If you're unable to do so you may want to look at StackOveflow and review their rules regarding asking question.
$endgroup$
– IvenBach
4 hours ago
add a comment |
$begingroup$
I am reading in the inputs from cell D24 and E24, then attempting to update cell D27, based off of the input I make in cell E24(1, 2, neither). Why is my code compiling correctly, but not outputting the correct value? I completed a debug and my "z" variable has the correct value, but it's not writing the value to the cell.
Sub UpdateD_27()
Dim x As Integer 'Declare variable for Starting Value
Dim y As Integer 'Declare variable for Choice/Editable Value
Dim z As Integer 'Declare variable for Answer
Dim m As String 'Declare variable for Message to User
x = ActiveWorkbook.Sheets("TabF").Range("D24").Value 'Set variable in memory storage location
y = ActiveWorkbook.Sheets("TabF").Range("E24").Value 'Set variable in memory storage location
z = ActiveWorkbook.Sheets("TabF").Range("D28").Value 'Set variable in memory storage location
If (y = 1) Then
z = x * 7
ElseIf (y = 2) Then
z = x / 7
Else
m = "Please enter the value 1 or 2 in cell E24."
End If
End Sub
vba excel
asked 4 hours ago
Tanner10Tanner10
1
New contributor
Tanner10 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
I am reading in the inputs from cell D24 and E24, then attempting to update cell D27, based off of the input I make in cell E24(1, 2, neither). Why is my code compiling correctly, but not outputting the correct value? I completed a debug and my "z" variable has the correct value, but it's not writing the value to the cell.
Sub UpdateD_27()
Dim x As Integer 'Declare variable for Starting Value
Dim y As Integer 'Declare variable for Choice/Editable Value
Dim z As Integer 'Declare variable for Answer
Dim m As String 'Declare variable for Message to User
x = ActiveWorkbook.Sheets("TabF").Range("D24").Value 'Set variable in memory storage location
y = ActiveWorkbook.Sheets("TabF").Range("E24").Value 'Set variable in memory storage location
z = ActiveWorkbook.Sheets("TabF").Range("D28").Value 'Set variable in memory storage location
If (y = 1) Then
z = x * 7
ElseIf (y = 2) Then
z = x / 7
Else
m = "Please enter the value 1 or 2 in cell E24."
End If
End Sub
vba excel
vba excel
asked 4 hours ago
Tanner10Tanner10
1
New contributor
Tanner10 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 hours ago
Tanner10Tanner10
1
New contributor
Tanner10 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 hours ago
Tanner10Tanner10
1
New contributor
Tanner10 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 hours ago
Tanner10Tanner10
1
asked 4 hours ago
Tanner10Tanner10
1
1
New contributor
Tanner10 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Tanner10 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Tanner10 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
put on hold as off-topic by AJNeufeld, Sᴀᴍ Onᴇᴌᴀ, 200_success, pacmaninbw, esote 3 hours ago
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Code not implemented or not working as intended: Code Review is a community where programmers peer-review your working code to address issues such as security, maintainability, performance, and scalability. We require that the code be working correctly, to the best of the author's knowledge, before proceeding with a review." – AJNeufeld, Sᴀᴍ Onᴇᴌᴀ, 200_success, pacmaninbw, esote
If this question can be reworded to fit the rules in the help center, please edit the question.
put on hold as off-topic by AJNeufeld, Sᴀᴍ Onᴇᴌᴀ, 200_success, pacmaninbw, esote 3 hours ago
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Code not implemented or not working as intended: Code Review is a community where programmers peer-review your working code to address issues such as security, maintainability, performance, and scalability. We require that the code be working correctly, to the best of the author's knowledge, before proceeding with a review." – AJNeufeld, Sᴀᴍ Onᴇᴌᴀ, 200_success, pacmaninbw, esote
If this question can be reworded to fit the rules in the help center, please edit the question.
1
$begingroup$
CodeReview is about already working code and has the requirement must contain code that is already working correctly. We can review your code once it's working correctly. If you're unable to do so you may want to look at StackOveflow and review their rules regarding asking question.
$endgroup$
– IvenBach
4 hours ago
add a comment |
1
$begingroup$
CodeReview is about already working code and has the requirement must contain code that is already working correctly. We can review your code once it's working correctly. If you're unable to do so you may want to look at StackOveflow and review their rules regarding asking question.
$endgroup$
– IvenBach
4 hours ago
1
1
$begingroup$
CodeReview is about already working code and has the requirement must contain code that is already working correctly. We can review your code once it's working correctly. If you're unable to do so you may want to look at StackOveflow and review their rules regarding asking question.
$endgroup$
– IvenBach
4 hours ago
$begingroup$
CodeReview is about already working code and has the requirement must contain code that is already working correctly. We can review your code once it's working correctly. If you're unable to do so you may want to look at StackOveflow and review their rules regarding asking question.
$endgroup$
– IvenBach
4 hours ago
add a comment |
0
active
oldest
votes
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
$begingroup$
CodeReview is about already working code and has the requirement must contain code that is already working correctly. We can review your code once it's working correctly. If you're unable to do so you may want to look at StackOveflow and review their rules regarding asking question.
$endgroup$
– IvenBach
4 hours ago