+ Reply to Thread
Results 1 to 5 of 5

Change cell value from 0 to 1 with button

  1. #1
    Registered User
    Join Date
    02-06-2017
    Location
    Arkansas
    MS-Off Ver
    365
    Posts
    4

    Smile Change cell value from 0 to 1 with button

    I need to change a cell value from 0 to 1 using some form of user interaction such as a button or other method.

    Application Detail:
    Column A - Numbered 0 or 1 representing used or unused
    Column B - Sequential Numbers 0-199999
    I have a VLookup function returning the first number in the sequence that has a 0 adjacent to it.
    I also have a Match function returning the row number that the VLookup result is in.
    I need to add a button or other interface that will write a value of 1 to Ax (where x is the result of the Match function) when pressed.
    Attached Files Attached Files
    Last edited by awnrycuss; 11-17-2020 at 07:57 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,872

    Re: Change cell value from 0 to 1 with button

    Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    02-06-2017
    Location
    Arkansas
    MS-Off Ver
    365
    Posts
    4

    Re: Change cell value from 0 to 1 with button

    I have edited my original post with an example attachment

  4. #4
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Change cell value from 0 to 1 with button

    Try

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-06-2017
    Location
    Arkansas
    MS-Off Ver
    365
    Posts
    4

    Re: Change cell value from 0 to 1 with button

    Thanks that worked perfectly!!!!! It took me a minute to figure out how the script was referencing Sheet 1 (B11) and not sheet 2. I assumed it was relative to the location of the button though?

+ 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. Press button to change cell background
    By Civion in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-21-2020, 02:42 PM
  2. Change cell value using Radio button
    By wisko in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-20-2019, 10:40 AM
  3. ActiveX Control Spin Button Copy Button and Change Cell reference?
    By chrstphrbllngs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2016, 04:01 PM
  4. On Click of button cell value should change
    By kmpcan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2016, 06:15 PM
  5. [SOLVED] Macro (Button) to Change cell value
    By dmarzean in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2013, 08:18 PM
  6. Change same cell on all sheets but the first with a command button
    By soadokdls in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2012, 08:38 PM
  7. [SOLVED] Change a cell's value using a button
    By Ash007 in forum Excel General
    Replies: 3
    Last Post: 03-17-2005, 11:06 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