Question

In: Computer Science

Record a macro that sets Cell B5 to a format of Bold and sets the Number...

Record a macro that sets Cell B5 to a format of Bold and sets the Number format to be in $.  Copy the VBA code for that macro and paste it.

Solutions

Expert Solution

Code

VBA macro

Sub Test()
Worksheets("Sheet1").Range("B5").Font.Bold = True
Worksheets("Sheet1").Range("B5").NumberFormat = " $#,##0.00;[Red]$#,##0.00"
End Sub

Output

In starting sheet is

when you run the macro

final output is

If you have any query regarding the code please ask me in the comment i am here for help you. Please do not direct thumbs down just ask if you have any query. And if you like my work then please appreciates with up vote. Thank You.

venereology answered 1 month ago
Next > < Previous

Related Solutions

Describe the function of each of the structures in bold in the previous question. -cell wall...
Describe the function of each of the structures in bold in the previous question. -cell wall -chloroplasts -chromoplasts -chromatin -cytoskeleton -leucoplasts -nuclear envelope -nucleolus -rough endoplasmic reticulum -smooth endoplasmic reticulum -vacuole -vesicles
determine a standardized health record format for a specific healthcare setting.
determine a standardized health record format for a specific healthcare setting.
TV sets: According to the Nielsen Company, the mean number of TV sets in a U.S....
TV sets: According to the Nielsen Company, the mean number of TV sets in a U.S. household in 2013 was 2.24. Assume the standard deviation is 1.2. A sample of 80 households is drawn. Use the Cumulative Normal Distribution Table if needed. Part 1 of 5 What is the probability that the sample mean number of TV sets is greater than 2? Round your answer to four decimal places. The probability that the sample mean number of TV sets is...
TV sets: According to the Nielsen Company, the mean number of TV sets in a U.S....
TV sets: According to the Nielsen Company, the mean number of TV sets in a U.S. household in a recent year was 2.24. Assume the standard deviation is 1.2. A sample of 85 households is drawn. What is the probability that the sample mean number of TV sets is between 2.5 and 3? Find the 30th percentile of the sample mean.
TV sets: According to the Nielsen Company, the mean number of TV sets in a U.S....
TV sets: According to the Nielsen Company, the mean number of TV sets in a U.S. household in 2013 was 2.24. Assume the standard deviation is 1.4. A sample of 80 households is drawn. Use the Cumulative Normal Distribution Table if needed. Part 1 of 5 What is the probability that the sample mean number of TV sets is greater than 2? Round your answer to four decimal places. The probability that the sample mean number of TV sets is...
TV sets: According to the Nielsen Company, the mean number of TV sets in a U.S....
TV sets: According to the Nielsen Company, the mean number of TV sets in a U.S. household in 2013 was 2.24 . Assume the standard deviation is 1.2 . A sample of 95 households is drawn. Use the Cumulative Normal Distribution Table if needed. What is the probability that the sample mean number of TV sets is greater than 2? Round your answer to four decimal places. What is the probability that the sample mean number of TV sets is...
Requirements: Record the deduction for group insurance. Record the health insurance deduction. Record the check number...
Requirements: Record the deduction for group insurance. Record the health insurance deduction. Record the check number assigned to each employee. Compute and record the net pay for each employee. Total the input columns on the Employee Payroll register. On Employer Register, enter total gross earnings. Prepare the journal entries as of January 12 to record the payroll and the payroll taxes for the week ending January 8. Credit Salaries Payable for the total net pay. Prepare the journal entry to...
As a result of mitosis cell (during cell division) of the Cell cycle, the number of...
As a result of mitosis cell (during cell division) of the Cell cycle, the number of chromosomes in the 2 new cells is a) used to eliminate mutations t, b) increased to 3 times the normal or diploid number, c) is reduced to 1/2 half of the diploid (normal) number representing one full set of chromosomes, d) is reduced to 1/2 the diploid number producing a random set of chromosomes, e) kept constant. The evolution of the three germ layers...
Prepare journal entries in general journal format to record the following transactions for the City of...
Prepare journal entries in general journal format to record the following transactions for the City of Dallas General Fund (subsidiary detail may be omitted) 1. The budget prepared for the fiscal year included total estimated revenues of $4,693,000, appropriations of $4,686,000 and estimated other financing uses of $225,000. 2. Purchase orders in the amount of $451,000 were mailed to vendors. 3. The current year’s tax levy of $4,005,000 was recorded; uncollectible taxes were estimated to be 2% of the tax...
File has a format Name and number, the number represents power. The name and the (integer)...
File has a format Name and number, the number represents power. The name and the (integer) power are separated by some amount of space. Importantly, any line that begins with a hash '#' are comments and they need to be ingored. Write a program that reads from that file, and prints out only the name of the hero with the strongest power. That name should be capitalized (not uppercase, but capitalized, as in 'Galadriel') Here is the heroes.txt # DC...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT