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