Userfrom problem...

T

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 |
+-------------------------------------------------------------------+
 
P

Paul Lautman

the said:
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.
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top