+ Reply to Thread
Results 1 to 5 of 5

how to stop Command button If specific number is entered in a specific cell range

  1. #1
    Forum Contributor sspreyer's Avatar
    Join Date
    07-05-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    178

    how to stop Command button If specific number is entered in a specific cell range

    hi
    im new to the forum have little vba knowledge thanks for you help in advance

    i would like disable a command button E.G if any cell in range N1:N200 has 123456 inputted

    any ideas

    i have search and havent found anything on this subject

    thanks again

    shane

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: how to stop Command button If specific number is entered in a specific cell range

    In the code for the command button include an if statement along the lines of:
    Please Login or Register  to view this content.

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: how to stop Command button If specific number is entered in a specific cell range

    Hello,

    your question is not very clear. Can you post a sample file, or at least the code that currently sits behind your command button?

    You can probably build an IF statement around the command button procedure, based on the currently selected cell and the other conditions. For details, please post a sample file and your code.

    cheers, teylyn

  4. #4
    Forum Contributor sspreyer's Avatar
    Join Date
    07-05-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: how to stop Command button If specific number is entered in a specific cell range

    hi
    here is the code behind my command button thanks again

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor sspreyer's Avatar
    Join Date
    07-05-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: how to stop Command button If specific number is entered in a specific cell range

    hi
    here is a test file i made to show what im trying to do

    thanks
    again

    shane

    test piece .xlsm
    Last edited by sspreyer; 07-26-2013 at 05:33 AM.

+ 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. Copy entered data for a specific date using a command button
    By SChapman in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 03-31-2013, 05:38 PM
  2. Need Toggle button to stop working once data entered into a specific cell
    By kwebbers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2013, 03:34 PM
  3. Display msgbox when specific text entered in specific range
    By Ali_Riza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2012, 08:05 AM
  4. Replies: 15
    Last Post: 10-11-2009, 11:46 AM
  5. command button that puts specific numbers in a range of cells
    By ko6ad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2006, 01:41 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