User form problem
 

Hi,

I have a workbook containing two sheets. The first sheet has a Use
Form that enters the data onto a second data sheet which is hidden. Ho
can I alert the user when the second hidden data sheet has data that ha
reached a certain row number?

--
Mike Ainswort
-----------------------------------------------------------------------
Mike Ainsworth's Profile: http://www.excelforum.com/member.php...fo&userid=2650
View this thread: http://www.excelforum.com/showthread.php?threadid=39810

User form problem
 

How do you determine where to store the data on that second sheet, which
row? Could you not just add a test in there to see if the row has reached
that number?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike Ainsworth"
<Mike.Ainsworth.1u7rub_1124795118.8326@excelforu m-nospam.com wrote in
message news:Mike.Ainsworth.1u7rub_1124795118.8326@excelfo rum-nospam.com...

Hi,

I have a workbook containing two sheets. The first sheet has a User
Form that enters the data onto a second data sheet which is hidden. How
can I alert the user when the second hidden data sheet has data that has
reached a certain row number?.


--
Mike Ainsworth
------------------------------------------------------------------------
Mike Ainsworth's Profile:
http://www.excelforum.com/member.php...o&userid=26501
View this thread: http://www.excelforum.com/showthread...hreadid=398100

User form problem
 

As the sheet is being populated with data, get the current
ActiveCell.Address. Now use string functions to extract the numeric
portion of the address. This indicates the current row which can serve
as a conditional expression in a control structure.