Home VBA Choose value to ListIndex 0
Reply: 0

VBA Choose value to ListIndex 0

BernardoRValle Published in 2018-01-12 13:43:10Z

I have a form wich I want to choose the ListIndex of a combobox2 depending on the value of another combobox1.

I tried to use the following code but didn't succeed.

Dim rng As Excel.Range
For Each rng In Sheets("CLIENTES").Range("F2:F300")
    If rng.Value = Me.cmbProfissional.Text Then
    Me.cmbProfissional.ListIndex(0) = rng.Value
    End If
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.473081 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO