Hello
Range A to K contains cliens details (name adres etc)
Range L to BS conains months from 2011 to 2016 where indicated the paymants
Range A1:BX1000 - Dynamic Range Named "LombardAll" contains clients contract numbers
So Combobox1 Rawsorce is "Lombard"
Depending on combobox1 value I want texbox1 to indicate the first unpaid month
Question 1
How the code will look like ?
Question 2 (if 1 question was hard)
How can I get the cell number of vlookup result ?
Something like that results with error.
File. (just in case)
Range A to K contains cliens details (name adres etc)
Range L to BS conains months from 2011 to 2016 where indicated the paymants
Range A1:BX1000 - Dynamic Range Named "LombardAll" contains clients contract numbers
So Combobox1 Rawsorce is "Lombard"
Depending on combobox1 value I want texbox1 to indicate the first unpaid month
Question 1
How the code will look like ?
Question 2 (if 1 question was hard)
How can I get the cell number of vlookup result ?
Something like that results with error.
Code:
Private Sub ComboBox1_Change()
me.textbox1.value = "Row N " & WorksheetFunction.Match(--Me.ComboBox1.Value, Worksheets("Esas").Range("LombardAll"), False)
End Sub
File. (just in case)
Last edited: