Requirements Use the Flowchart to the left to write VBA code for the Sub named Degrees so that it converts Fahrenheit into Celsius. The Sub should run when you click the button that says Convert (s…
Requirements
Use the Flowchart to the left to write VBA code for the Sub named Degrees so that it converts Fahrenheit into Celsius. The Sub should run when you click the button that says Convert (so, you’ll need to assign it to the macro). If no value is entered into B4, then a message box should pop up that says “Fahrenheit missing.” Your code should delete the contents of cell B5 before running the calculation so that when Fahrenheit is missing it returns no value. Please use the variable names shown in the flowchart (F and C). Fahrenheit and Celsius should both be declared as variable types that can handle decimals. You cannot use worksheet functions for this problem. Comment your code so that it is easy for a grader to follow. Points will be deducted if it is poorly commented.Image transcription text= HO’«.DOOJOU’I-IDUJIJI—’ Fahrenheit Celsius 30 Points Possible Convert Requirements Use the Flowchart to the left to
write VBA code for the Sub named Degrees so that it converts Fahrenheit into Celsius. The Sub should run when you click the
button that says Convert (so, you’ll need to assign it to the macro). If no value is entered into B4, then a message… Show more… Show more
OR