Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-08-2014, 08:52 AM
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 This is a Userform LIstbox queston: A variable does not set to the value of a listbox

Hello forum and thank you for taking time to read this. I am completely stuck on what I think is a simple problem but I have invested several hours so far an cannot crack this one. Maybe one of you will be able to identify a fix. I have included an attachement that is a watered down verison of the big program and makes it fast and easy to see what I am stuck on.
In a nut shell, the statement
S11 = Uf_CertPlan_Owner.Lb_TeamPerformance


S11 is suppose to set to the value of a listbox but it remains blank. S11 is declared as a string and the value in the list box is "High" but after running this line of code the variable S11 remains blank. But S12 and S13, set in a similar manner do set correctly so why does S11 refuse to set to high?
Please open the excel workbook and double click any cell to launch the "menu of services" userform, then follow the process and you will be prompted to control-break and read some remarks in the code that will show you exactly where the variable is being set but if you hover your mouse over the variable you will see it is blank.
Attached Files
File Type: xlsm PBM_Help v3.xlsm (87.7 KB, 15 views)
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 12:28 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