+ Reply to Thread
Results 1 to 4 of 4

select case calculations not working

  1. #1
    Forum Contributor
    Join Date
    05-09-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2016
    Posts
    543

    select case calculations not working

    I have a multi-step VBA (Classify) that the calculations do not seem to be working. I have put an example here:
    https://app.box.com/s/na2a9bq02x7v9szjs9vl

    I have a worksheet_change event:

    VB
    Please Login or Register  to view this content.
    that is supposed fire the Calculations (Step 5) when the user selects the case in A2. That doesn't seem to be working and I need some expert help figuring this out. Thank you.

    Classify VBA:
    VB
    Please Login or Register  to view this content.
    Calculations VBA:
    VB
    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: select case calculations not working

    You seem to be calling Calculations with an argument, but the Calculations sub doesn't take any arguments.

    Also, there's no Select Case in the code.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    05-09-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2016
    Posts
    543

    Re: select case calculations not working

    I am not sure I follow as I am still new to VBA. How should Calculations be called and is this a better select case statement? Thanks.

    VB
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    05-09-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2016
    Posts
    543

    Re: select case calculations not working

    Are the codes below correct or close ? Thanks.

    For the worksheet_change event in the annovar sheet (where the A2 selection is made):
    VB
    Please Login or Register  to view this content.
    Select case
    VB
    Please Login or Register  to view this content.

+ 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] Select Case statements after Search String not working
    By rdowney79 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-10-2013, 03:04 PM
  2. Select Case possibly not working as intended. (Another strange bug)
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2013, 10:40 AM
  3. my Select Case function is not working correctly
    By DorothyFan1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-25-2011, 07:56 AM
  4. [SOLVED] Case Select not working
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2010, 06:53 AM
  5. Select Case not working
    By RadBrad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-31-2009, 01:11 AM

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