Results 1 to 3 of 3

textbox enter

Threaded View

  1. #1
    Registered User
    Join Date
    02-18-2012
    Location
    Dubrovnik
    MS-Off Ver
    2010
    Posts
    20

    textbox enter

    I wana put name of the product (cell j2) in label3 on userform. I wana triger that action after i press enter in textbox1. How do i do that?
    Here is the code.


    Private Sub CommandButton1_Click()
    Sheets("TABLICA").Select
    Dim sifra As Integer
    Dim kolicina As Double
    sifra = TextBox1.Value
    kolicina = TextBox2.Value
    Worksheets("TABLICA").Cells(2, "E").Value = sifra
    Worksheets("TABLICA").Cells(2, "K").Value = kolicina
    Range("A1:C131").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
    "TABLICA!Criteria"), CopyToRange:=Range("TABLICA!Sifnaz"), Unique:=False
    Range("I2:K2").Select
    Selection.Copy
    Sheets("GALETA1").Select
    NextRow = Range("A65536").End(xlUp).Row + 1
    Range("A" & NextRow).Select
    ActiveSheet.Paste
    Sheets("TABLICA").Select
    Application.CutCopyMode = False
    'Range("I2:K2").ClearContents
    Sheets("GALETA1").Select
    TextBox1.Text = ""
    TextBox2.Text = ""
    TextBox1.SetFocus
    End Sub
    Last edited by sipcine; 03-10-2012 at 01:42 PM.

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