vue 签名验证,校验数据_使数据验证列表看起来更大

vue 签名验证,校验数据

When you create a drop down list with data validation, you can't change the font or font size. If you have reduced the zoom setting for a worksheet, it can be difficult to read the items in the list. And even at 100%, it can tough to read the tiny print, at the end of a long workday. Here's how you can make data validation list appear larger.

使用数据验证创建下拉列表时，无法更改字体或字体大小。 如果您减小了工作表的缩放设置，则可能很难阅读列表中的项目。 甚至在100％的情况下，在漫长的工作日结束后，也很难阅读细小的印刷品。 这是使数据验证列表更大的方法。

放大以阅读列表 (Zoom In to Read the List)

To make the data validation text appear larger, you can use a bit of VBA code to increase the zoom setting when a data validation cell is selected. (Note: this can be a bit jumpy)

要使数据验证文本看起来更大，可以在选择数据验证单元格时使用一些VBA代码来增加缩放设置。 (注意：这可能有点跳动)

The following code will change the zoom setting to 120% when any cell with a data validation list is selected. If you select a cell without a data validation list, the zoom reduces to 100%.

当选择了带有数据验证列表的任何单元格时，以下代码会将缩放设置更改为120％。 如果您选择一个没有数据验证列表的单元格，则缩放比例将减小到100％。

缩放码 (The Zoom Code)

Add this code to the worksheet module for the sheet with data validation cells.

将此代码添加到带有数据验证单元的工作表模块中。

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  Dim lZoom As Long
  Dim lZoomDV As Long
  Dim lDVType As Long
  lZoom = 100
  lZoomDV = 120
  lDVType = 0
  Application.EnableEvents = False
  On Error Resume Next
  lDVType = Target.Validation.Type
    On Error GoTo errHandler
    If lDVType <> 3 Then
      With ActiveWindow
        If .Zoom <> lZoom Then
          .Zoom = lZoom
        End If
      End With
    Else
      With ActiveWindow
        If .Zoom <> lZoomDV Then
          .Zoom = lZoomDV
        End If
      End With
    End If
exitHandler:
  Application.EnableEvents = True
  Exit Sub
errHandler:
  GoTo exitHandler
End Sub

更多缩放选项 (More Zoom Options)

To see other sample code for changing the zoom setting, see the Data Validation Tips page on the Contextures website.

若要查看用于更改缩放设置的其他示例代码，请参见Contextures网站上的“ 数据验证提示”页面。

翻译自: https://contexturesblog.com/archives/2012/09/25/make-data-validation-list-appear-larger/

vue 签名验证,校验数据