Dave,
Try using something like the following, assuming cell which
activates Userform is still "active" (selected):

Do you want to select ALL boxes BEFORE putting data into sheet? If so,
perhaps use a command button to initiate this.


....place in appropriate macro e.g Commandbutton1_click

myrow=Activecell.row


Cell(myrow,"B")=Textbox2.value
Cell(myrow,"C")=Textbox3.value


etc


"dmexcel" wrote:


Hi,
I am making a UserForm with four list boxes so that the user will click
on an item from each box click OK and then a miricle happens!!
The UserForm shows up when a cell in column "A" has been changed.
how do I get the list boxes taged to the cells in the same row say
B,C,D,E for example purposes, so that whatever row I am on the info in
the listboxes will insert into the appropriate columns.?
Thanks alot, if anybody has an answer this will make the sheet so much
faster.
Dave