Easy Newbie Question
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Easy Newbie Question

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    first the names
    excel workbook = project(4)
    sheet with dialog box = DiaQuart
    in sheet diaquart there's my textbox= Date
    answer should go to same workbook,
    sheet= rapport, cell=D3
    ---------------------------------
    my question
    please answer step by step because i am ery good in excel but looks like i cant understand nothing from vba even the dumbest
    line of code!!

    ok i've made a dialog box, i have a lot of textbox that the user has to fill in with his info. i want these info to be copied to a specific cell in my worksheet(rapport(D3))
    when the user press the ok button.

    should be easy to answer isint it?
    cant figure it out!!

    Thanks
    MAZ

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Private Sub CommandButton1_Click()
    Worksheets("Rapport").Range("d3") = Worksheets("Diaquart").TextBox1.Text
    End Sub

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    still dont work!
    Maz

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    anayone can send me an simple example
    of how to copy the data from a textbox in a msgbox to a worksheet so i can compare the code
    thanks
    maz

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com