Wednesday, August 18, 2010

Microsoft Excel Help?

I want to display a message box using VBA when the number of rows in an Microsoft EXCEL worksheet exceeds 120 rows.



Can this be done?



Please provide me with the sample coding if possible.



Thank you



Microsoft Excel Help?free antivirus



I assume you mean when the number of rows (containing data) get 121. Of course this can be done - you're gonna have to write a macro for it... but then, you also need to define an event to run the macro - examples of event are



** Click of a button



** Opening of the excel workbook



etc.



You have to decide two things -



1. What defines a 'filled row' (ie, when would you consider the row as containing data)



2. When and how would you like the check to be performed (ie the event).



Once you provide the above two details - I could help you write the code.



.



Microsoft Excel Help?internet



This is the macro that you need.



If your list is in column A, then...



Then in B1 paste this function



=COUNTA( A:A)



Just open the VBE for that file,



In that exact sheet paste this in the code area for it



Private Sub Worksheet_Change(ByVal Target As Range)



If Range(''B1'').Value %26gt; 120 Then



MsgBox ''You exceeded the up limits (120)'', vbCritical



End If



End Sub



Enjoy my profile, I am the VBAXLMan
Try here:



http://vbaexpress.com/kb/default.php



You don't have to join. Just hit ''List Entries''.

No comments:

Post a Comment