hi is it possible to write something like zoom-in and zoom-out button...
嗨是可以写像放大和缩小按钮...
for example i will have a userform on which i will have two buttons one for each zoom in and out... whenever the user clicks on one of the buttons plus user clicks the cells (or selects the range) that cell or range will be increased or decreased using the ActiveWindow.Zoom option....
例如,我将有一个用户形式,我将有两个按钮,每个放大和缩小一次...每当用户点击其中一个按钮加上用户点击单元格(或选择范围)该单元格或范围将是使用ActiveWindow.Zoom选项增加或减少....
if this is possible plz can you tell me how? thanks a lot!
如果这是可能的,请告诉我怎么样?非常感谢!
1 个解决方案
#1
Try ActiveWindow.Zoom = 50 within your VBA. That will set your zoom to 50%.
在您的VBA中尝试ActiveWindow.Zoom = 50。这会将您的缩放设置为50%。
#1
Try ActiveWindow.Zoom = 50 within your VBA. That will set your zoom to 50%.
在您的VBA中尝试ActiveWindow.Zoom = 50。这会将您的缩放设置为50%。