ComboBox.Text doesn`t work

**esential** · 01-11-2010, 04:17 AM

hello,

i want to make a command form, but CommandBox.Text doesn`t work.

i attached the .xls file and this is the code:

Please Login or Register  to view this content.

Thank you!

**royUK** · 01-11-2010, 04:56 AM

You mean ComboBox.

Your code is overwriting each entry because it is copying each combobox value to the same cell. Also, it is extremely inefficient,looping each time to find the next empty cell.

Try this

Please Login or Register  to view this content.

Also,I don't know what size monitor you are using, but the form is way too big

**esential** · 01-11-2010, 05:04 AM

Thank you

now i have another question ..

if i want to insert another row when appear first empty cell, what i have to do?
because maybe i`ll write some details on the end of the command form.

**royUK** · 01-11-2010, 05:06 AM

The code that I posted will find the next empty row each time

**esential** · 01-11-2010, 05:19 AM

i know, but how can i make if i want to put the information from combobox to an inserted row, that is between first empty cell and last writed cell?

is a problem in code that you have written, because if i fill cell b2, next cell will be filled from combobox, but will edit cell b2 too with the information from combobox.

**royUK** · 01-11-2010, 05:31 AM

Originally Posted by esential

i know, but how can i make if i want to put the information from combobox to an inserted row, that is between first empty cell and last writed cell?

is a problem in code that you have written, because if i fill cell b2, next cell will be filled from combobox, but will edit cell b2 too with the information from combobox.

The code that I provided will only write to the next empty cell in B. I can't see why you need to insert a row

**esential** · 01-11-2010, 05:42 AM

it`s a command form
in top of page i have identification of company and in bottom of the page i have total price of command and some commercial stuffs.
that`s the reason that i need to insert another row.

the code you have written is working, but if i write in 2 ore more combobox will put the products from combobox in b3,c3,d3,e3 .. etc. and i need b3,b4,b5,b6 etc.

sorry for my english and thank you for help!