Hi guys,
I'm having an issue with a vba form.
The form has a list, in which I write all the distinct shape masters found on the page.
When a master is selected a subroutine shall select all the shapes belonging to this master.
The sub-routine starts with a activewindow.desellectall, then goes through all shapes and adds the right shape to the selection.
The issue is, that when I use the mouse to chose a master the deselection does not work.
Changing the value by keyboard does not show the problem.
Setting a break at the deselection line, also works without problem.
It looks like clicking in the form does change the activewindow.
But this does not make sense, because working with the keyboard would also not work.
Strange...
Option Explicit
Private Sub listMasters_AfterUpdate()
Dim shp As Shape
ActiveWindow.DeselectAll
For Each shp In ActivePage.Shapes
If Not shp.Master Is Nothing Then
If shp.Master = listMasters.value Then
ActiveWindow.Select shp, visSelect
End If
End If
Next shp
End Sub
Private Sub UserForm_Initialize()
getMasters
End Sub
Private Sub getMasters()
Dim Col As New Collection
Dim shp As Shape
Dim itm
For Each shp In ActivePage.Shapes
On Error Resume Next
Col.Add shp.Master, shp.Master
On Error GoTo 0
Next shp
listMasters.Clear
For Each itm In Col
listMasters.AddItem itm
Next
End Sub
I think you might need something like:
Forms.Application.ProcessMessages
or the equivalent in VBA.
Sounds like "doevents". I couldn't find a better one.
It did however not work.
But duplicating the deselection line, did help.
Ugly!
Thanks for the help.
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: 765KB.
Tokens:
post-login.
Cache hits: 7: 0.00107s for 22,301 bytes (
showget modSettings: 0.00050s - 19982 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.00011s - 980 bytes, get log_online-update: 0.00009s - 10 bytes, get menu_buttons--1-english: 0.00002s - 0 bytes)
Cache misses: 1: (
showget menu_buttons--1-english)
Queries used: 9.
[Show Queries]