Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MatchEntry for combobox added during runtime
Hi,
I hope one of you Gurus can help me on this one. How can i set MatchEntry for this combobox ? KontrolNavn = "Kontrol" & X + 1 Set mycmd = UserForm2.Controls.Add("Forms.combobox.1", KontrolNavn, True) With mycmd .Left = 170 .Top = 5 + X * 20 .Width = 100 .RowSource = Cells(Target.Row + X + 1, 4).Value .Value = Cells(Target.Row + X + 1, Target.Column).Value End With Regards Claus |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MatchEntry for combobox added during runtime
in teh code below, I removed your lines to make the additions a bit
clearer...I hope! Dim mycmd As ComboBox Set mycmd = _ UserForm2.Controls.Add("Forms.combobox.1", KontrolNavn, True) With mycmd .MatchEntry = fmMatchEntryComplete End With "Claus" wrote: Hi, I hope one of you Gurus can help me on this one. How can i set MatchEntry for this combobox ? KontrolNavn = "Kontrol" & X + 1 Set mycmd = UserForm2.Controls.Add("Forms.combobox.1", KontrolNavn, True) With mycmd .Left = 170 .Top = 5 + X * 20 .Width = 100 .RowSource = Cells(Target.Row + X + 1, 4).Value .Value = Cells(Target.Row + X + 1, Target.Column).Value End With Regards Claus |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MatchEntry for combobox added during runtime
Hi Patrick
Sorry i was'ent expressing myself clearly, but i've triede this and it did'nt work. Claus "Patrick Molloy" skrev i en meddelelse ... in teh code below, I removed your lines to make the additions a bit clearer...I hope! Dim mycmd As ComboBox Set mycmd = _ UserForm2.Controls.Add("Forms.combobox.1", KontrolNavn, True) With mycmd .MatchEntry = fmMatchEntryComplete End With "Claus" wrote: Hi, I hope one of you Gurus can help me on this one. How can i set MatchEntry for this combobox ? KontrolNavn = "Kontrol" & X + 1 Set mycmd = UserForm2.Controls.Add("Forms.combobox.1", KontrolNavn, True) With mycmd .Left = 170 .Top = 5 + X * 20 .Width = 100 .RowSource = Cells(Target.Row + X + 1, 4).Value .Value = Cells(Target.Row + X + 1, Target.Column).Value End With Regards Claus |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
MatchEntry for combobox added during runtime
Sorry Patrick
It works. I'm using the wrong property, i need to make sure that the user only can select a listitem and type something else. Claus "Patrick Molloy" skrev i en meddelelse ... in teh code below, I removed your lines to make the additions a bit clearer...I hope! Dim mycmd As ComboBox Set mycmd = _ UserForm2.Controls.Add("Forms.combobox.1", KontrolNavn, True) With mycmd .MatchEntry = fmMatchEntryComplete End With "Claus" wrote: Hi, I hope one of you Gurus can help me on this one. How can i set MatchEntry for this combobox ? KontrolNavn = "Kontrol" & X + 1 Set mycmd = UserForm2.Controls.Add("Forms.combobox.1", KontrolNavn, True) With mycmd .Left = 170 .Top = 5 + X * 20 .Width = 100 .RowSource = Cells(Target.Row + X + 1, 4).Value .Value = Cells(Target.Row + X + 1, Target.Column).Value End With Regards Claus |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
MatchEntry for combobox added during runtime
Hi again
Now i'm using With mycmd .MatchEntry = fmMatchEntryComplete .MatchRequired = True ... ... End With but the MatchRequired dos'ent work with my combos added during runtime. I've triede with a combobox added manually and it works. Claus "Patrick Molloy" skrev i en meddelelse ... in teh code below, I removed your lines to make the additions a bit clearer...I hope! Dim mycmd As ComboBox Set mycmd = _ UserForm2.Controls.Add("Forms.combobox.1", KontrolNavn, True) With mycmd .MatchEntry = fmMatchEntryComplete End With "Claus" wrote: Hi, I hope one of you Gurus can help me on this one. How can i set MatchEntry for this combobox ? KontrolNavn = "Kontrol" & X + 1 Set mycmd = UserForm2.Controls.Add("Forms.combobox.1", KontrolNavn, True) With mycmd .Left = 170 .Top = 5 + X * 20 .Width = 100 .RowSource = Cells(Target.Row + X + 1, 4).Value .Value = Cells(Target.Row + X + 1, Target.Column).Value End With Regards Claus |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
MatchEntry for combobox added during runtime
..Style = 2
HTH. Best wishes Harald "Claus" skrev i melding ... Sorry Patrick It works. I'm using the wrong property, i need to make sure that the user only can select a listitem and type something else. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
MatchEntry for combobox added during runtime
Thank you Harald
Regards, Claus "Harald Staff" skrev i en meddelelse ... .Style = 2 HTH. Best wishes Harald "Claus" skrev i melding ... Sorry Patrick It works. I'm using the wrong property, i need to make sure that the user only can select a listitem and type something else. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textbox added to Form at runtime too small, can't control size andchange event won't trigger | Excel Worksheet Functions | |||
Textbox added to Form at runtime too small, can't control size andchange event won't trigger | Excel Worksheet Functions | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
add event to controls added in runtime | Excel Programming | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming |