User Profile

Collapse

Profile Sidebar

Collapse
Sickbock
Sickbock
Last Activity: Oct 7 '13, 08:15 AM
Joined: Oct 4 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Sickbock
    replied to Changing screen resolution in Excel by VBA?
    in Visual Basic
    Thanks Rabbit for your help
    I have changed the code as shown below. This works

    Code:
    Sub change()
Call change_resolution(1280, 1024)
End Sub
    See more | Go to post

      Leave a comment:

    • Sickbock
      replied to Changing screen resolution in Excel by VBA?
      in Visual Basic
      Thanks Rabbit for your quick response. This was a little bit stupid indeed. But now I am immediately facing the next problem. When I write a procedure to call the function to change the screen resolution, the automatic fill up function of VBA wants me to add a sign of equality behind the expression "change_resolut ion(1280, 1024)". But I do not know what to add behind the sign of equality. I now put a x behind it, and the screen resolution...
      See more | Go to post

        Leave a comment:

      • Sickbock
        started a topic Changing screen resolution in Excel by VBA?
        in Visual Basic

        Changing screen resolution in Excel by VBA?

        I have a computer that can manually be switched to 2 monitors. Both monitors do not have the same screen resolution. I am running a macro controlled presentation in Excel 2010 and I want to change the screen resolution when switching to the other monitor. In a previous post, “Change Screen Resolution using VB”, I found the following solution:

        Code:
        '************************************************* ****************
' DECLARATIONS SECTION
        ...
        See more | Go to post
        Last edited by Rabbit; Oct 4 '13, 05:58 PM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.
        No activity results to display
        Show More
        Working...