LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel recognise cell contents as a cell reference sincln21 Excel Discussion (Misc queries) 2 February 25th 09 02:31 PM
Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... [email protected][_2_] Excel Programming 2 June 7th 07 09:27 PM
another macro is running ... how to recognise that process in code??? Matthew Dodds Excel Programming 6 April 24th 07 12:08 AM
Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste JenIT Excel Programming 4 April 12th 07 08:56 PM
Recognise filter in macro and ignore. malycom Excel Programming 1 June 22nd 04 01:34 PM


All times are GMT +1. The time now is 10:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"