Feedback

VBA

To change a comment in cell A1, which will do the job?

Range("A1").Comment.Text("My Comment")

Range("A1").Comment("My Comment")

Range("A1") = "My Comment"

Range("A1").Text("My Comment")

Answer:
Range("A1").Comment.Text("My Comment")

Note: This Question is unanswered, help us to find answer for this one

Previous

Next

More VBA MCQ Questions

Combine into one line: If x > 5 Then y = x - 5 End If

To change the text displayed in a label on a form, choose the VBA code that will allow you to update the property.

Which code will allow user to edit a password protected worksheet.

When stepping through code as a way to see how the values in variables change, use the:

Choose the VBA code that will allow you to verify that an Item exists in the Dictionary object Dict1.

Choose the VBA code that you would use to call a public function named VBAFunction from a form called FormA while passing a variant x1 in the module of FormB form.

When you have added a new linked table using VBA code and it does not appear in Navigation Pane that displays the list of tables, forms, macros, and queries in the database. Which VBA code would you use to update the list of database objects displayed in the Navigation Pane.

What will Format(“A123”, “&&&&&&”) output?

Which is NOT a method of the Workspace object:

You want to count how many records for a given customer based on CustomerID which is of field type short text in table tblCustomer. The customer id we want the count for is 123-AC. We are using the domain aggregate function DCount and assign it to an integer variable intC what is the correct syntax.