+ Reply to Thread
Results 1 to 4 of 4

different cell inputs in different cells

Hybrid View

adkliko different cell inputs in... 08-30-2010, 04:24 AM
royUK Re: differend cel inputs in... 08-30-2010, 04:56 AM
adkliko Re: differend cel inputs in... 08-30-2010, 05:49 AM
adkliko Re: different cell inputs in... 08-31-2010, 02:55 AM
  1. #1
    Registered User
    Join Date
    08-30-2010
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    3

    different cell inputs in different cells

    Hai all.
    I'm a total new bee on VBA and learn now in the past day's a lot.
    But i stubbled on to a problem.
    I hope you all can help we with it.

    The script that i post works the way i want it but it is working only on one cel.
    Explanation off the script:
    When you put the letters TVT in cel A1 then the script gives a inputbox.
    The inputbox fills a different cel with the value you type in the inputbox.
    If you delete the tekst TVT than it gives you a warning.

    Can somewone make from 3 scripts one?

    
    Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    If Target.Address(0, 0) = "A1" Then
        Select Case LCase(Target.Value)
            Case "tvt": Call tvturen
            Case Else: MsgBox "Do not Delete"
        End Select
    End If
    Application.EnableEvents = True
    End Sub
    
    Sub Numeric_tvturen()
    
    If Range("A1").Value = "tvt" Then
        tvtsub
        End If
       End Sub
    Sub tvtsub()
    
    UserValue = InputBox("TVT uren")
    Range("A10").Value = UserValue
    
    End Sub
    Last edited by adkliko; 08-31-2010 at 02:54 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: differend cel inputs in differend cels

    Which cells do you mean, is it one column?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    08-30-2010
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: differend cel inputs in differend cels

    Hai Roy.

    No it is not one colum but colum G to NL.
    You fill in TVT in cel A1 and the awnser of the box comes in A10.
    The only way now for me is to duplicate the VBA script 365 times te let i work in al planning calender

  4. #4
    Registered User
    Join Date
    08-30-2010
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: different cell inputs in different cells

    Has someone a idee to do this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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