xzoom

Hello, I have a VBA code for a worksheet help me to increase the window zoom when I select the drop down menu. With this code I can see the drop down menu text in appropriate font size. Here is the code: Private Sub Worksheet_SelectionChange(ByVal Target As Range)...

Hi I currently have the following code that when I click on a pulldown menu it zooms in then when you clicks of zooms out. What I want is to still zoom in but once I click on selection it zooms out and selects range B1:s10 and copys the selection. I'm not sure if its possible to zoom out and...

Hi all, I am trying to create a workbook for one of my bosses. What he wants is a workbook to list various options against various topics of a property. That I can easily do with data validation. However when you use the dropdown, the text is always small and he would be using this on a Surface...

Hello all. I have this bit of code running in my worksheet. Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'updateby Extendoffice 20160530 On Error GoTo LZoom Dim xZoom As Long xZoom = 100 If Target.Validation.Type = xlValidateList Then xZoom = 130 LZoom...