+ Reply to Thread
Results 1 to 12 of 12

Form Control Buttons

Hybrid View

  1. #1
    Registered User
    Join Date
    04-06-2013
    Location
    USA
    MS-Off Ver
    MS Office Professional Plus 2019
    Posts
    77

    Re: Form Control Buttons

    Thank you so much for your help.

    I have tried the “Clicker” and it works just great.

    Per the attachment, you can see the “Clicker” work.

    As each number is “Clicked”, the sheet calculates the Standard Deviation.

    For the 1st number Clicked which is number 4 and it is shown in Cell A5. The Standard Deviations (SD) for # 4 and all other numbers are shown in Cells EE5 to FO5.

    What I need help to do is to put each SD in the SD Columns I2 to I19 and K2 to K20. So after #4 is Clicked those columns would show the SD in Cells EE5 to FO5.

    When the next number is clicked, # 22, SD Columns I2 TO i19 AND k2 TO k20 will show the SD in Cells EE6 to FO6. Etc.

    Hope I made myself clear and again thanks for all your help.

    Cheers
    Nick
    Attached Files Attached Files

+ 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. Jittery Form Control Option Buttons
    By BDD2015 in forum Excel General
    Replies: 1
    Last Post: 02-03-2017, 02:36 PM
  2. Hide a Chart with Form Control Buttons
    By shamsul in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-10-2016, 08:16 AM
  3. [SOLVED] Command Buttons Form Control or ActiveX
    By Epscan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2014, 01:41 PM
  4. Form control buttons creep
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-08-2014, 12:59 PM
  5. [SOLVED] How do i replicate Form Control Buttons in a spreadsheet?
    By msalib888 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-11-2014, 11:09 PM
  6. Adding Form Control Buttons
    By wildlifegis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-15-2012, 01:55 AM
  7. How to insert NICE Form Control Buttons
    By sunilmulay in forum Excel General
    Replies: 3
    Last Post: 10-08-2009, 11:30 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