Hello,
I'm building a VBA userform to enter Grocery Stores names and address information into a worksheet named “Stores”. Each store will have a sequential “store number” in Column A. What I need help on is the VBA code that will automatically create the next available sequential number (“0004” based on sample below) and assign it to a variable or similar, so I can add it to my “save_data_button()” code that I'll have on the userform.
Although I don’t use the worksheet function; “=LARGE(A:A,1)+1", I see that it's one way to get the next sequential number in column A, but not sure it will work in VBA or if it's the best method.
I'd appreciate any help or pointer to another post with similar needs.
Cesar
Store NO. (A) Store Name (B)
0001 Safeway
0002 Savemart
0003 Winco
Bookmarks