VB Code to insert a row and populate column A with next doc # using button

I’m new to writing VB code and created the attached form.

I want to be able to click “New Entry” button on the form and it will add a row at A3 on the spreadsheet. I want to populate the next document number available (SB######) in A3.

Also, is there a way the new number can show up on the Entry form automatically in highlighter yellow portion shown?

 

Thank-you in advance for any help given!

VB Code to insert a row and populate column A with next doc # using button

New Member Asked on November 4, 2016 in VBA: User Forms.
Add Comment
1 Answer(s)

Hi, Please refer this project, it is similar to your requirement:

http://analysistabs.com/vba-code/excel-projects/data-entry-userform/

Thanks!

Keymaster Answered on November 4, 2016.
Add Comment
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.