Display/Show related procedures in class Worksheet (Excel VBA)

This page presents procedures from class Worksheet related to the theme Display/Show: DisplayRightToLeft, ShowAllData and ShowDataForm

DisplayRightToLeft

True if the specified worksheet is displayed from right to left instead of from left to right. False if the object is displayed from left to right.

ActiveSheet.DisplayRightToLeft = True

ShowAllData

Makes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All.

ActiveSheet.ShowAllData

ShowDataForm

Displays the data form associated with the worksheet.

The macro pauses while you are using the data form. When you close the data form, the macro resumes at the line following the ShowDataForm method. This method runs the custom data form, if one exists.

ActiveSheet.ShowDataForm