+ Reply to Thread
Results 1 to 2 of 2

Using Select Case to Manage Production

Hybrid View

  1. #1
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2007
    Posts
    11

    Question Using Select Case to Manage Production

    I'm trying to use a Select Case to log production time-tables.
    I've tried a couple angles - one being Select Case.
    Every time I run the Macro I get the default ERROR "Wrong Model Entered...."

    Private Sub Transfer()
    
    Dim ModR As String
    Dim Count1 As Integer
    Dim Count2 As Integer
    Dim Count3 As Integer
    Dim Count4 As Integer
    Dim Count5 As Integer
    
    Count1 = 0
    Count2 = 0
    Count3 = 0
    Count4 = 0
    Count5 = 0
    
    ModR = Worksheets(1).Range("B3").Value
    
    Select Case ModR
        Case "Model 1"
            Worksheets(1).Range("B4:B6").Copy
            Worksheets(2).Range("B3:B5").Offset(Count1, 0).PasteSpecial
            Count1 = Count1 + 1
        Case "Model 2"
            Worksheets(1).Range("B4:B6").Copy
            Worksheets(2).Range("B7:B9").Offset(Count2, 0).PasteSpecial
            Count2 = Count2 + 1
        Case "Mode1 3"
            Worksheets(1).Range("B4:B6").Copy
            Worksheets(2).Range("B11:B13").Offset(Count3, 0).PasteSpecial
            Count3 = Count3 + 1
        Case "Model 4"
            Worksheets(1).Range("B4:B6").Copy
            Worksheets(2).Range("B15:B17").Offset(Count4, 0).PasteSpecial
            Count4 = Count4 + 1
        Case "Model 5"
            Worksheets(1).Range("B4:B6").Copy
            Worksheets(2).Range("B19:B21").Offset(Count5, 0).PasteSpecial
            Count5 = Count5 + 1
        Case Else
            MsgBox "Wrong Model Entered / Model Does Not Exist"
        End Select
    End Sub
    
    Public Sub call_Transfer()
        Call Transfer
    End Sub
    I'm thinking the problem lies within
    ModR = Worksheets(1).Range("B3").Value
    but I'm not certain.

    Any suggestions???

  2. #2
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Using Select Case to Manage Production

    HRS01.PNG
    HRS02.PNG

    These are images of the layout.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need the proper syntax to use Case/Select Case in vba properly.
    By rbion in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2013, 02:34 PM
  2. [SOLVED] Disregard case in VBA code. (UCase, LCase, Select Case)
    By Orestees in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-07-2012, 12:12 PM
  3. Case Select compile error "Case without case select"
    By coasterman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2012, 06:50 AM
  4. Case Select....The alternative method for long "Select Case"
    By kimyap in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2008, 01:24 AM
  5. [SOLVED] Select case / case is, multiple arguments
    By Werner Rohrmoser in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-03-2006, 07:00 AM

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