Scribd Logo
Upload

Welcome to Scribd!

  • 49 views

    Visual Basic: VBA For Visio - Change Layer Object Properties

    Uploaded by

    Jemerald
    The document is a collection of posts from the subreddit r/visualbasic discussing various issues and questions about Visual Basic programming. The posts cover topics such as modifying layer visibility in Visio using VBA, running a SQL query on form load in VB.NET, converting metrics between meters and centimeters, and referencing forms and controls by name using a composed string.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Visual Basic: VBA For Visio - Change Layer Object Properties

    Uploaded by

    Jemerald
    49 views12 pages
    The document is a collection of posts from the subreddit r/visualbasic discussing various issues and questions about Visual Basic programming. The posts cover topics such as modifying layer visibility in Visio using VBA, running a SQL query on form load in VB.NET, converting metrics between meters and centimeters, and referencing forms and controls by name using a composed string.

    Original Title

    Visual Basic

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document is a collection of posts from the subreddit r/visualbasic discussing various issues and questions about Visual Basic programming. The posts cover topics such as modifying layer visibility in Visio using VBA, running a SQL query on form load in VB.NET, converting metrics between meters and centimeters, and referencing forms and controls by name using a composed string.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    49 views12 pages

    Visual Basic: VBA For Visio - Change Layer Object Properties

    Uploaded by

    Jemerald
    The document is a collection of posts from the subreddit r/visualbasic discussing various issues and questions about Visual Basic programming. The posts cover topics such as modifying layer visibility in Visio using VBA, running a SQL query on form load in VB.NET, converting metrics between meters and centimeters, and referencing forms and controls by name using a composed string.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 12

    7/11/22, 8:27 PM Visual Basic

      r/visualbasic Search Reddit 

    Visual Basic Join

    r/visualbasic

     Hot  

    Posted by u/Beneficial-Rule4015 7 hours ago

    VBA for Visio - Change Layer Object properties


    I am attempting to write a VBA macro for Visio, which performs the following:

    1. Iterates over each page of the current document


    2. Iterates over each layer of the page
    3. Checks if layer name matches a specified textual pattern
    4. If true, change layer's visibility to hidden

    Based on the Layer object documentation, I don't see how I can modify the "Visible" property.

    For reference, here's how it looks from within the UI inside the "layer properties" dialog box. How would I
    modify "Visible" from within the Layer Object using VBA?

     3   3 Comments  Share 

    u/discoveryplus • Promoted

    Never before seen footage. Exclusive interviews. Unprecedented times.

    https://www.reddit.com/r/visualbasic/ 1/12
    7/11/22, 8:27 PM Visual Basic

      r/visualbasic Search Reddit 

    discoveryplus.com/ca Sign Up

     2   0 Comments  Share

    Posted by u/DoggoDragonZX 10 hours ago

    VB6 Help How do i make the array be the entire first column except the first row.

     3   1 Comment  Share

    https://www.reddit.com/r/visualbasic/ 2/12
    7/11/22, 8:27 PM Visual Basic

    Posted by u/Mr_Deeds3234 1 day ago


      r/visualbasic Search Reddit 
    VB.NET Help Delegates, invoking, multithreading
    CONTEXT I have a winsform project with multiple forms. One of those forms has a button associated with
    a pretty heavy SQL query that takes about 30 seconds to execute.

    I would like this query to run on the page load if the first form, so if my user navigates to the form that
    needs the data, then it’s already there and they don’t have to wait.

    Spent a few hours googling this problem and the concepts in the title is why I found. I haven’t quite been
    able to figure out my solution.

    Is there some other concept or keywords I should look into and understand to over come my problem?

     5   4 Comments  Share

    Posted by u/Dangerous_Lake_7834 1 day ago

    I need help.
    I am trying to create a metric program but having a hard time converting meters to centimeters and
    removing the initial whole number in the front.

     1   1 Comment  Share

    Posted by u/cheecho82 3 days ago

    Does anyone remember Code Genie, created by boolan?


    It was back in day, I was trying to find some info on it but couldn’t. Does anyone know what if taking about
    ???

     5   3 Comments  Share

    Posted by u/Ajido 10 days ago

    VB6 HelpHow to fix this? "Option Strict On disallows implicit conversions from
    'Single' to 'Integer'"
    Hi there, I'm very new to VB and a program I have to write some scripts in uses it. The error happens after
    I added the following function:

    https://pastebin.com/tbZ2MSA9

    If I change Option Strict to Off, it compiles and works fine, it only throws the error when Strict is On. I'd
    just like to learn and understand what mistake I'm making. What here is the Single that is being
    complained about converting to an Int?

     2   5 Comments  Share 

    Posted by u/Character_Tackle_423 10 days ago

    Data validation
     0  4 Comments  Share

    https://www.reddit.com/r/visualbasic/ 3/12
     
    7/11/22, 8:27 PM Visual Basic

     r/visualbasic
     
    Posted by u/DoggoDragonZX 10 days ago
    Search Reddit 
    I'm trying to sort a list of codes in excel that consist of Letters(normally two
    VB6 Help

    but sometimes three) followed by a number(number of digits vary from 1-3). Full
    explanation will be in the comments. Here is a testing list of codes, and the code I
    have made so far.

     2   5 Comments  Share 

    u/hellofreshca • Promoted

    Antoni wants to give you up to 20 free meals off HelloFresh. Don’t be rude. Accept
    his offer, Reddit!

    https://www.reddit.com/r/visualbasic/ 4/12
    7/11/22, 8:27 PM Visual Basic

      r/visualbasic Search Reddit 

    hellofresh.ca Order Now

     103   0 Comments  Share

    Posted by u/freswinn 11 days ago

    VB.NET Help Referencing a Form/Control By Name Via Composed String


    In another scripting language I've been learning (GDScript), if you want to reference a "node" (that
    language's equivalent to a form, control, etc.), you can sort of build that thing's name with code. For
    example:

    If I have 12 buttons on screen, each named Button1, Button2, etc., I can say

    get_node("Button" + str(num)).text = "This is Button " + str(num)

    and this will change the text on the button whose number is "num" and change what it says based on its
    own number.

    What would be the equivalent of that in Visual Basic? I have 20 buttons that I want to reference with a
    single function based on the numerical value at the end of their names. Here's what I tried, knowing full-

     2   5 Comments  Share 

    https://www.reddit.com/r/visualbasic/ 5/12
    7/11/22, 8:27 PM Visual Basic

      r/visualbasic Search Reddit 

    https://www.reddit.com/r/visualbasic/ 6/12
    7/11/22, 8:27 PM Visual Basic

      r/visualbasic Search Reddit 

    https://www.reddit.com/r/visualbasic/ 7/12
    7/11/22, 8:27 PM Visual Basic

      r/visualbasic Search Reddit 

    https://www.reddit.com/r/visualbasic/ 8/12
    7/11/22, 8:27 PM Visual Basic

      r/visualbasic Search Reddit 

    https://www.reddit.com/r/visualbasic/ 9/12
    7/11/22, 8:27 PM Visual Basic

      r/visualbasic Search Reddit 

    https://www.reddit.com/r/visualbasic/ 10/12
    7/11/22, 8:27 PM Visual Basic

      r/visualbasic Search Reddit 

    https://www.reddit.com/r/visualbasic/ 11/12
    7/11/22, 8:27 PM Visual Basic

      r/visualbasic Search Reddit 

    https://www.reddit.com/r/visualbasic/ 12/12

    You might also like