+ Reply to Thread
Results 1 to 3 of 3

auto number form

  1. #1
    alex.simms
    Guest

    auto number form

    I would like to include a text box in a form in which the number in the box
    will increment by one each time textbox1 is filled.
    can any one suggest a method of achieving this

    --
    regards
    ALEX



  2. #2
    Jim Thomlinson
    Guest

    RE: auto number form

    No easy way except using VB... If this is a workbook where more than 1 copy
    will exist then you neet to create a text (or database which is my personal
    favorite) file on a network drive and access that through code. If there will
    be only one copy of the file then it is easier to get unique incremented
    numbers. Just store a number on a hidden sheet somewhere and increment it
    when required...

    HTH

    "alex.simms" wrote:

    > I would like to include a text box in a form in which the number in the box
    > will increment by one each time textbox1 is filled.
    > can any one suggest a method of achieving this
    >
    > --
    > regards
    > ALEX
    >
    >
    >


  3. #3
    Charles Harmon
    Guest

    Re: auto number form

    Alex,

    Here is a code that will start the listbox text with "0" then each time you
    Tab or press the Enter key on textbox2 Textbox1 will increment. You need to
    set the Property value of Textbox1 Text to "0".

    HTH

    Charles

    Private Sub Textbox2_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal
    Shift As Integer) 'tab key
    Application.ScreenUpdating = False
    If KeyCode = "9" Or KeyCode = "13" Then
    With UserForm1
    .TextBox1.Text = .TextBox1.Text + 1
    End With
    End If
    End Sub

    "alex.simms" <[email protected]> wrote in message
    news:[email protected]...
    >I would like to include a text box in a form in which the number in the box
    >will increment by one each time textbox1 is filled.
    > can any one suggest a method of achieving this
    >
    > --
    > regards
    > ALEX
    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1