Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 08-08-2014, 12:38 PM
CatMan CatMan is offline This is a Userform LIstbox queston: A variable does not set to the value of a listbox Windows 7 32bit This is a Userform LIstbox queston: A variable does not set to the value of a listbox Office 2010 32bit
Intermediate
This is a Userform LIstbox queston: A variable does not set to the value of a listbox
 
Join Date: Apr 2012
Posts: 39
CatMan is on a distinguished road
Default

Sub ReloadCertPlanOwner() is only used to reload Uf_CertPlan_Owner (not Uf_AirplaneCertSubCat). However I have other modules that do the same thing (with minor tweaks) for other userforms. Currently the code is setting the 3 listboxes while the userform has not yet been shown (it is not in hide, it has not yet been lauched). Do you think that is the problem? But how do I set the 3 listboxes once the userform is shown? Am I not correct to say that code exicution stops once you issue Uf_AirplaneCertSubCat.show?

Ok I just changed the code to launch Uf_CertPlan_Owner.SHOW prior to setting the 3 listboxes, code exicution does stops and the userform appears incomplete (because code exicution stopped prematurely).

I just changed the code to launch Uf_CertPlan_Owner.HIDE prior to setting the 3 listboxes, code exicution does not stops and the SowMaturity listbox does not set (the other two listboxes set ok).

Last edited by CatMan; 08-08-2014 at 01:08 PM. Reason: changed load to set,added another paragraph
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
This is a Userform LIstbox queston: A variable does not set to the value of a listbox Moving Selected Items from a Multiselect Listbox on a userform to a bookmark in Word marksm33 Word VBA 3 01-15-2015 07:55 PM
This is a Userform LIstbox queston: A variable does not set to the value of a listbox This is a Userform LIstbox queston: A variable does not set to the value of a listbox CatMan Excel 1 08-08-2014 09:41 AM
Checkboxes are unchecked in Listbox that were checked off before.How can I stop this? Rochelle711 Excel Programming 0 06-22-2014 06:16 PM
This is a Userform LIstbox queston: A variable does not set to the value of a listbox Multi-select listbox help gvibe@hotmail.com Word VBA 1 07-19-2013 10:54 AM
as the return value of another column, using Listbox? marreco Excel Programming 1 03-27-2012 12:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:11 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