Results 1 to 6 of 6

On Click of button cell value should change

Threaded View

  1. #1
    Registered User
    Join Date
    03-25-2015
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    7

    On Click of button cell value should change

    Hi,

    I have a workbook with 2 sheets Data and Form.
    Data Sheet has data in column 1
    and Form sheet has a Form.

    in the form sheet :
    Cell B13 =Data!A3

    I have a button in form sheet what i want is that if whenever i click on the button the value in B13 should change to the next value in the list in data spreadsheet in this case it should be =Data!A4. If i click again it should be =Data!A5 and so on. if the list ends that means if cell value = blank then display "ERROR list over".

    Attaching the sample spreadsheet. Will Really appreciate your help.
    Attached Files Attached Files
    Last edited by kmpcan; 01-06-2016 at 03:58 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change function from on button click to when value entered
    By rmc71291 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-12-2015, 09:47 AM
  2. [SOLVED] Change protection options with a button click?
    By rrbee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2014, 11:42 AM
  3. [SOLVED] click on a color button and after button click it will color entire row of cell you click
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-11-2014, 06:06 PM
  4. How change label value for each click button ??
    By WILKER in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 11-02-2012, 12:25 PM
  5. Command Button to change the subsequent rows with each click
    By sand_electro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 04:13 PM
  6. VBA to change writeup at the click of button.
    By arnab0711 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2012, 03:19 AM
  7. Undo Button Click change
    By Kiran in forum Excel General
    Replies: 2
    Last Post: 07-12-2005, 03:05 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