Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-17-2024, 11:38 AM
annguye2 annguye2 is offline WordVBA: list object in .dotm file Mac OS X WordVBA: list object in .dotm file Office 2021
Novice
WordVBA: list object in .dotm file
 
Join Date: Jul 2024
Posts: 22
annguye2 is on a distinguished road
Default

Thanks.



I am using Mac, and it can't open the UserForm in design view.. So I can't apply your suggestion.
How do you find the UserForm name in the code?
I only have this in Form Initialize stage
Private Sub UserForm_Initialize()
With TemplateName
.AddItem "Template 1"
.AddItem "Template 2"
.AddItem "Template 3"
.AddItem "Template 4"
.AddItem "Template 5"
.AddItem "Template 6"
End With
End Sub••••ˇˇˇˇ
Reply With Quote
  #2  
Old 07-17-2024, 11:53 AM
annguye2 annguye2 is offline WordVBA: list object in .dotm file Mac OS X WordVBA: list object in .dotm file Office 2021
Novice
WordVBA: list object in .dotm file
 
Join Date: Jul 2024
Posts: 22
annguye2 is on a distinguished road
Default

Ok so I found the way to look for the UserForm Name
Debug.Print "Form Name: " & Me.Name



But when using what you suggested,


Templat_Selection.Show vbModeless

it's jump into error handler
***Error pulling document! ErrHandler: Case 0004 ****
Any idea why it's bad?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to determine Windows Zoom level when using multiple monitors with different settings in WordVBA? skarden Word VBA 0 09-12-2023 03:49 AM
instance a new dotm file from a Word dotm file and save with new file name David Peck Word VBA 3 08-18-2023 06:47 AM
I have Error at File System Object: Cant find object or lib johndrew Word VBA 3 07-05-2018 08:46 PM
WordVBA: list object in .dotm file Editing .dotm/.dotx/dot file martinlest Word 9 10-09-2013 01:57 PM
WordVBA: list object in .dotm file Macros being stripped from dotm file Brian Muth Word 1 10-09-2012 10:00 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft