View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
adrian adrian is offline
external usenet poster
 
Posts: 4
Default Vba add data to cell from userform

Hi all,

I am new to Exell but have been tinkering with VBA in Word.
I would be very grateful if someone could set me off in
the right direction with this little task.

I have a userform that has 4 listboxes in.

Any suggestions on how best to code exell so the the
result from each of the listboxes are entered into
worksheet cells on the next available row.

ie
Listbox1 result = "Dog"
Listbox2 result = "Cat"

Find first row with no data added. Add "Dog" to cell ?1.
Add "Cat" to cell ?2 etc etc.

Any help with code would be much appreciated.

Adrian