Userfrom problem...

[the dude]

Hi guys,
When I insert the data in the Userform, it's not going to fill the
database.
I am sure there are a problem with the combobox or at least I think..
Could you please help me???
Thanks a lot


+-------------------------------------------------------------------+
|Filename: matrix3.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4829 |
+-------------------------------------------------------------------+

 

[Paul Lautman]

Hi guys,
When I insert the data in the Userform, it's not going to fill the
database.
I am sure there are a problem with the combobox or at least I think..
Could you please help me???
Thanks a lot


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

Why can't the owners of www.excelforum.com fix the attachment addresses
aaaarrrrrrggggghhhhhh!!!!!!!!

Anyway, when I try to run it it tells me that the control called Tier
doesn't exist and looking at the form it doesn't exist. So I guess that's
the reason. ou need to name the combo boxes with the same names that you use
in the script.

 

[Toppers]

You are assigning the labels associated with the comboboxes (etc) rather than
the combobox itself.

e.g.

ws.Cells(iRow, 2).Value = Me.Tier.Value

should be

ws.Cells(iRow, 2).Value = Me.ComboBox14.Value

HTH

 

[CaptainP]

try this (at least 10 chars)


+-------------------------------------------------------------------+
|Filename: matrix3.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4830 |
+-------------------------------------------------------------------+