Transfering data from UserForm to specific cell

[Ben Sherman]

Hello, I new and I have dummy question! Remember I am new!

I have created new UserForm with few comboBoxes. Data inside are from some lists on other Sheet.

how to tell that picked value must be inserted to specific column on other Sheet?

I have more ComboBoxes and I want to do that with all of them!

Sorry for dummy Q!! :doh:

[Tinbendr]

For instance...
Worksheets(2).Range("A1") = ComboBox1.Value

[Ben Sherman]

THX, that works fine for TextBox, but when I choose value in comboBox then i got FALSE entry...

[GTO]

Greetings Ben,

Welcome to the vbaexpress :-)

Maybe attach an example wb with how you have the code now, or leastwise post the code. Use the '...your code tags to post code.

Mark

[Ben Sherman]

Ok, I have solve that (I dont know how), but I have new proble:

1. how to clear user form?
2. how to put new entries to new row?

Thx in advance!

[GTO]

Ok, I have solve that (I dont know how), but I have new proble:

1. how to clear user form?
2. how to put new entries to new row?

Thx in advance!

I think you may need to be a bit more descriptive. By 'clear user form', I suppose you mean clear comboboxes? The second question seems less clear.

Please attach a small sample workbook with your userform and a description of what we are trying to do.

Thanks,

Mark

[shrivallabha]

There is one Excel File in the program named MTO_R1 which I had prepared.

It has got a userform. It will provide you with many different cases to refer to.

Here it is:

http://www.vbaexpress.com/forum/showthread.php?t=32670

[Ben Sherman]

Thx, I have maid to do what I wont.

Now I have UserForm from whitch users can load data to Excel, but there is problem when I moving up and down in excel (with form buttons serForm1.red.Value = UserForm1.red.Value - 1).

I have values in excel in first 10 rows, but when I moving up and down my UserForm is empty! How can I make that already inputed data showing on my form?

Thx in advanced! :hi: