NessPJ
Active Member
- Joined
- May 10, 2011
- Messages
- 422
- Office Version
- 365
Hello there,
I'm trying to show a value/text in a Label on my Userform when the user clicks a certain value in a Combobox.
Worksheets have a _change value Event. Is there something similar for a Userform? I can't seem to find it...
This is some of the code i use: [Menu.Artikel1 is my Combobox]
Something like this should be in a VBA routine/event when the Value changes and the field(s)/form is updated, i think: [Menu.ArtikelOmschrijving is my Text Label]
Does anyone know how to do this?
I'm trying to show a value/text in a Label on my Userform when the user clicks a certain value in a Combobox.
Worksheets have a _change value Event. Is there something similar for a Userform? I can't seem to find it...
This is some of the code i use: [Menu.Artikel1 is my Combobox]
VBA Code:
Dim RowART1 As Long
Dim LastRowTagART1 As Long
Dim ArtikelOmschrijving As String
LastRowTagART1 = ThisWorkbook.Sheets("Parameters").Range("M22").End(xlUp).Row
'De inhoud voor lijst met Artikelen wordt dynamisch opgebouwd (Combobox Artikel1).
With Menu.Artikel1
For RowART1 = 4 To LastRowTagART1
.AddItem Sheets("Parameters").Range("M" & RowART1).Value
Next RowART1
End With
Something like this should be in a VBA routine/event when the Value changes and the field(s)/form is updated, i think: [Menu.ArtikelOmschrijving is my Text Label]
VBA Code:
'Find(Searchstring As String, SearchSheet As String, SearchColumn As String)
ArtikelOmschrijving = Find(Menu.Artikel1.Text, "Parameters", "M")
Menu.ArtikelOmschrijving.Caption = ArtikelOmschrijving
Does anyone know how to do this?