I have created a command button1 in excel. When I clicked on that button Serial No.should come in the colulmn A1 and If I click next time it should come in A2. What is the VBA code that i should linked to the command button1? Please suggest.
The serial no.should be 1 2 3 4 ..............etc..
Type 1 in A1 cell and for rest use this
rgds
Please Login or Register to view this content.
johnjohns
You shouldn't need VBA. If the column is part of a table of data then using
=Row(a1-1 and converting the data to an Excel 2007 Table will mean that as you continue to enter data in the Table the formula will copy itself & give you the relevant serial number
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks