Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-31-2018, 06:13 AM
Cosmo Cosmo is offline Show userForm from variable Windows Vista Show userForm from variable Office 2007
Competent Performer
Show userForm from variable
 
Join Date: Mar 2012
Posts: 240
Cosmo is on a distinguished road
Default

Thanks for the response.



I tried to replicate your results and at first, it wasn't working. Then I noticed that you dimmed the array as 'Object', when I had it as 'UserForm'. That seems to be the trick in getting it to work. Odd that the generic 'Object' works, but the specific 'UserForm' doesn't. I'm a bit rusty in VisualBasic, so these issues are easy to stumble upon.

I believe I now have what I need to get what I wanted to work. Thanks again.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show userForm from variable Assigning a string variable to a userform label caption Larry_1 Excel Programming 3 12-18-2017 06:59 AM
Show userForm from variable Show Userform when Content Control CheckBox ticked derajlance Word VBA 1 05-13-2016 01:55 PM
Using Userform.Show in Excel 2013 BillCPA Excel Programming 0 05-04-2015 09:52 AM
Command button to show userform suddenly stopped working jpb103 Word VBA 0 05-22-2014 06:05 AM
Show userForm from variable Show userform without losing document focus? Or other method to get a graphic to pop? AlexR Word VBA 7 03-31-2013 12:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:17 PM.


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