Userfrom problem...
 

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

--
the dude
------------------------------------------------------------------------
the dude's Profile: http://www.excelforum.com/member.php...o&userid=32838
View this thread: http://www.excelforum.com/showthread...hreadid=547211

Userfrom problem...
 

the dude wrote:
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 |
+-------------------------------------------------------------------+

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.

Userfrom problem...
 

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


"the dude" wrote:


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

--
the dude
------------------------------------------------------------------------
the dude's Profile: http://www.excelforum.com/member.php...o&userid=32838
View this thread: http://www.excelforum.com/showthread...hreadid=547211

Userfrom problem...
 

try this (at least 10 chars)


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

--
CaptainP
------------------------------------------------------------------------
CaptainP's Profile: http://www.excelforum.com/member.php...o&userid=34520
View this thread: http://www.excelforum.com/showthread...hreadid=547211