I am using a "CustomTag" to store information about the part being dropped on the page. The tag is part of the larger stencil and i am needing to fill in two property fields when the part is first dropped on the page. My issue i'm having is my current code will change a single instance of Custom Tag if multiple are on the page but not the one that is newly dropped.I am needing only the tag that was dropped to be changed. I am calling the macro from the events shape sheet. My test code is below. Any Help would be appreciated.
Public Sub Set_Tag()
Dim shpObj As Visio.Shape
Dim cellobj As Visio.Cell
Dim Rev_Number As Integer
Dim Proj_Number As Double
Dim TheShapes As Shapes
Rev_Number = 1
Proj_Number = 16212.01
' Obtain the list of shapes
Set TheShapes = ActivePage.Shapes
' Holds individual shape data.
Dim ThisShape As Shape
Dim ShapeNames As String
Dim showForm As String
' Obtain each shape and add it to the list.
For Each ThisShape In TheShapes
ShapeNames = ShapeNames + ThisShape.Name + vbCrLf
If ThisShape.Name = "CustomTag" Then
MsgBox "here"
ThisShape.CellsU("Prop.Revision") = Rev_Number
ThisShape.CellsU("Prop.Project") = Proj_Number
End If
Next
End Sub
The newly dropped shape ought to be selected, so just use the selected shape rather than looping thru the shapes collection.
Wapperdude
The issue is the tags are shapes grouped within the larger stencil... so when the stencil is dropped there are a number of shapes selected.
Browser ID: smf
(is_webkit)
Templates: 1:
Printpage (default).
Sub templates: 4:
init,
print_above,
main,
print_below.
Language files: 1:
index+Modifications.english (default).
Style sheets: 0:
.
Hooks called: 47 (
showintegrate_autoload, cache_get_data, integrate_pre_load, integrate_load_session, integrate_verify_user, cache_get_data, integrate_user_info, integrate_load_board, cache_get_data, integrate_board_info, cache_get_data, integrate_allowed_to_general, integrate_pre_load_theme, cache_get_data, integrate_allowed_to_general, integrate_simple_actions, integrate_allowed_to_general, integrate_load_theme, integrate_pre_log_stats, cache_get_data, integrate_actions, integrate_pre_parsebbc, integrate_bbc_codes, integrate_bbc_print, integrate_post_parsebbc, integrate_pre_parsebbc, integrate_bbc_print, integrate_post_parsebbc, integrate_pre_parsebbc, integrate_bbc_print, integrate_post_parsebbc, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_menu_buttons, integrate_current_action, integrate_theme_context, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general)
Files included: 25 - 925KB. (
show/home/iw0lkfe3x6cq/public_html/vgforum/index.php, /home/iw0lkfe3x6cq/public_html/vgforum/Settings.php, /home/iw0lkfe3x6cq/public_html/vgforum/cache/db_last_error.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/QueryString.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Subs.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Subs-Auth.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Errors.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Load.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Security.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Subs-Compat.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Subs-Db-mysql.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Cache/CacheApi.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Cache/CacheApiInterface.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Cache/APIs/FileBased.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Subs-Charset.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Unicode/Metadata.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Unicode/QuickCheck.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Session.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Logging.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Class-BrowserDetect.php, (Current Theme)/languages/index.english.php, (Current Theme)/languages/Modifications.english.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Printpage.php, (Current Theme)/Printpage.template.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Unicode/CaseUpper.php)
Memory used: 772KB.
Tokens:
post-login.
Cache hits: 7: 0.00119s for 22,302 bytes (
showget modSettings: 0.00061s - 19983 bytes, get known_languages: 0.00016s - 1277 bytes, get board_parents-0: 0.00011s - 2 bytes, get permissions:-1: 0.00008s - 50 bytes, get theme_settings-1: 0.00010s - 980 bytes, get log_online-update: 0.00011s - 10 bytes, get menu_buttons--1-english: 0.00002s - 0 bytes)
Cache misses: 1: (
showget menu_buttons--1-english)
Queries used: 9.
[Show Queries]