View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zak Zak is offline
external usenet poster
 
Posts: 144
Default userform macro to recognise non-blank cell

Hi,

I would like a code to recognise the first non-blank cell and input the info
into there via a userform. so the person enters the info into a userform and
then each of the textboxes should go into specified cells in a new sheet.
Each time new info is enterted the old info should still be there and the new
one should go at the bottom of that etc. please can you kindly provide code
for one textbox, i will replicate for the rest.

thanks.