Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
have some problem with database | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |