Search:
Type: Posts; User: drmerby3737
Search:
Search took 0.04 seconds.
-
Thanks for the quick reply! I think I am going to put each individual status, along with the other information that goes with it, in it's own node, then just color each node with the correct color....
-
Hello,
I am trying to color the text in a node in a treeview using Visual Basic 2008. I can easily do this by using the forecolor property (currentNode.ForeColor = Color.Red). The tricky part is...
-
Thanks for the simplification. I am adding a lot of nodes and information in between each part number so this has allowed me to remove A LOT of code. Thanks again!
-
-
Hello,
I am currently attempting to devise an algorithm that will take a list of part numbers with their corresponding levels and create a Tree View. Here is a sample of the data I am using...
...
-
How embarrassing! Thanks koolsid!
-
Hi,
I have written some code to loop through all the shapes in a sheet and color specific text if found. I get an error if the shape I select happens to be a group. How can I check if the selected...
-
Thanks for your help. I just found the solution but do not understand it. This works...
wApp.activesheet.shapes("ID1").select However this does not...
wSheet.shapes("ID1").select I have wSheet =...
-
Thanks for looking into this! I tried using shapes.range but with no luck. I have simplified the problem however. All I need to be able to do now is access a shape that I have previously named. If I...
-
I am writing my code in Visual Basic 2008. I am trying to store the shapes I have added to an Excel sheet in an array and get this error message...
"Interface...
-
-
This does not work. Let me be more specific. I am essentially trying to convert a line of excel vba code to Visual Basic. The code works in Excel vba. Here is the original code with no...
-
Hi all,
I am using Visual Basic 2008 to manipulate some data in a spreadsheet. I am having a problem using Excel's built in RemoveDuplicates function. Here is the line of code I need to fix...
...
-
That worked great! Thanks for your help!
-
Still not working. Here is a code snippet of what I am trying to accomplish...
Dim s As Excel.Shape
For Each s In wSheet.Shapes
If s.GroupItems.Count > 0 Then
...
-
Thanks for the response! I am looking for a solution using Excel VBA, not Visio. I apologize if my post was confusing. Any chance there is a way to check this using Excel VBA? I am also trying to...
-
I am trying to ungroup all shapes in a worksheet. I start with a copied drawing from Visio and that creates one group in Excel. I ungroup this and then there are some shapes, and another group. I...
|
Click Here to Expand Forum to Full Width
|