When I click on the Finished button on my UserForm, I want the ListBox1 Text
to go into the active cell and TextBox1 text to go into the cell immediately
below that and TextBox2 text to go into the cell immediately below that.

Hi

the code would be

activecell.value = listbox1.value
activecell.offset(1,0).value = textbox1
activecell.offset(2,0).value = textbox2

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Patrick Simonds" wrote in message
...
When I click on the Finished button on my UserForm, I want the ListBox1
Text to go into the active cell and TextBox1 text to go into the cell
immediately below that and TextBox2 text to go into the cell immediately
below that.