Results 1 to 6 of 6

Select Case problem

Threaded View

saziz Select Case problem 08-31-2015, 02:38 PM
Norie Re: Select Case problem 08-31-2015, 02:40 PM
saziz Re: Select Case problem 08-31-2015, 02:46 PM
jaslake Re: Select Case problem 08-31-2015, 02:51 PM
saziz Re: Select Case problem 08-31-2015, 03:07 PM
jaslake Re: Select Case problem 08-31-2015, 03:50 PM
  1. #1
    Forum Contributor
    Join Date
    02-19-2004
    Location
    San Francisco Bay Area
    MS-Off Ver
    Microsoft 365 Aps for enterprise.
    Posts
    241

    Select Case problem

    Hi,
    I am trying to make this macro work, but apparently I am nod doing it right.
    Appreciate very much your help in this regard.
    Sub CaseSelect_macro()
    
    Dim ws As Worksheet
    Dim pNbr As Range
    
    
    pNbr = InputBox("Please type in Pod# you like to load")
    
    Select Case pNbr
    
    
    Case Is = 1
    
    UserForm1.Show
    
    Set ws = Worksheets("Rack")
        ws.Cells(4, 3).Value = TextBox1.Value
        ws.Cells(5, 3).Value = TextBox2.Value
        ws.Cells(6, 3).Value = TextBox3.Value
        ws.Cells(7, 3).Value = TextBox4.Value
        ws.Cells(8, 3).Value = TextBox5.Value
       Unload Me
       
    Case Is = 2
    
    UserForm2.Show
    
    Set ws = Worksheets("Rack")
        ws.Cells(4, 6).Value = ComboBox1.Value
        ws.Cells(5, 6).Value = TextBox2.Value
        ws.Cells(6, 6).Value = TextBox3.Value
        ws.Cells(7, 6).Value = TextBox4.Value
        ws.Cells(8, 6).Value = TextBox5.Value
    Unload Me
    End Select
    
    End Sub
    Thank you
    Saziz
    Last edited by Leith Ross; 08-31-2015 at 03:55 PM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Select Case problem
    By Darthzo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-28-2012, 11:49 AM
  2. select case problem
    By jippii in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-11-2011, 06:05 PM
  3. select case problem
    By waltron in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2010, 05:47 AM
  4. Problem with Select Case construction
    By s80NL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2009, 05:49 PM
  5. Long Select Case Problem
    By dsrt16 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2009, 09:58 PM
  6. [SOLVED] Having Problem with Select Case
    By haroldj@shfoodbank.org in forum Excel General
    Replies: 2
    Last Post: 07-26-2006, 06:15 PM
  7. Select case and Last Cell Problem
    By JamesBurrows in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2006, 12:55 PM
  8. Select Case Statement Problem
    By maperalia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2006, 02:10 PM

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