In your example my code as posted worked fine, but in the UserForm were shown the set values. You see from this, your code walks on thin ice.
Quote:
|
...I have appended ".value" to each of the code lines above and that worked pefectly
|
The default property of a ListBox is .value, so you haven't actually changed anything. As you can see in my last posting, I tried this as well, but the problem remained therefore I tried the .List-property. What I want to say: Your new code will probably have some trouble soon again
It is generally adviseable to use the especific property:
Code:
Uf_CertPlan_Owner.Tb_TotalQTY.Text = Sheet18.Cells(C1, 2).Value
Uf_CertPlan_Owner.Lb_TeamPerformance.Value = Sheet18.Cells(C1, 3).Value
Uf_CertPlan_Owner.Lb_ProgramPlan.Value = Sheet18.Cells(C1, 4).Value
Uf_CertPlan_Owner.Lb_SowMaturity.Value = Sheet18.Cells(C1, 5).Value
... that also makes clear - when reading the script - that a TextBox contains text though the contains might be numeric. An important thing to keep in mind when using contains of a TextBox.
Edit:
Haven't yet seen your new post, you will have to change "Sub ReloadCertPlanOwner()" and probably sa well the calls to Show the next UserForm...
08-08-2014, 11:50 AM
Similar Threads
Moving Selected Items from a Multiselect Listbox on a userform to a bookmark in Word
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode