VBA, Please help with C.Box,filtering through 2 Comboboxs, column count doesnt work

[leonhuynh2006]

Dear all bro,

Please help with the combo box. How could I make the ComboBox3 in the enclosed file display 2 columns (Colour and Size)

I am sorry that I cant file upload file when posting new thread, please check the following link:
http://www.mediafire.com/download/tm...n+displays.xls

Thanks all,
Regards

[6StringJazzer]

Your media site requires installation of a download manager, and I'm not going to install more software just to download your 55K file. Please remove that link and use our attachment feature.

To attach a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
3. In the pop-up, click Add then Select to select a file from your local drive
4. Click the Upload button to upload the file
5. Click Done to attach it.

It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.

[leonhuynh2006]

I am sorry to make a mistake. However, mediafire requires no installation to download my file. Anyway, thanks for your instructions. I have fixed the issue. Please help me with the main question of combo box. Thanks very much

[6StringJazzer]

I would suggest this modification to your code for one Sub in Module1. I suggest loading the combobox directly, including the second column. This is not as fast as building a list and assigning the entire list, but doesn't matter for a small list.

However, in running this I am getting an error 380 on the red line and cannot determine the cause. I will continue to diagnose this.

Please Login or Register  to view this content.