Good Day,
Iam having difficulty on setting up a dynamic Combobox in my userform.
The VBA stop executing the 'DINAMIC COMBOBOX
Procedure is:
If REG2.Text = "KCA Deutag" Then
REG1.Enabled = True
FModification.Visible = True
FrameQuery.Visible = False
FOutputbox.Visible = True
CMDSave.Enabled = True
'DINAMIC COMBOBOX
Worksheets("DBDB").Range("J3", Range("J" & Rows.Count).End(xlUp)).Name = "Dynamic"
REG7.RowSource = "Dynamic"
Worksheets("DBDB").Range("AK3", Range("AK" & Rows.Count).End(xlUp)).Name = "Dynamic1"
REG8.RowSource = "Dynamic1"
'MAX LENGHT NUMBER
REG1.MaxLength = 5
End If
If REG2.Text = "3rd Party Company" Then
REG1.Enabled = False
Label2.Visible = True
REG17.Visible = True
'DINAMIC COMBOBOX
Worksheets("DBDB").Range("P3", Range("P" & Rows.Count).End(xlUp)).Name = "Dynamic"
REG7.RowSource = "Dynamic"
Worksheets("DBDB").Range("BM3", Range("BM" & Rows.Count).End(xlUp)).Name = "Dynamic1"
REG8.RowSource = "Dynamic1"
'MAX LENGHT NUMBER
REG1.MaxLength = 7
End If
End Sub
Your guys help on this matter is more then welcome
Bookmarks