+ Reply to Thread
Results 1 to 5 of 5

excel selection button

  1. #1
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    456

    excel selection button

    Hi everyone
    in the attached workbook there are some selection buttom
    The selection button 2 change the letters with this formula
    Please Login or Register  to view this content.
    it is possible to do with the 3 words H3:H5 ?
    I hope I have explained
    thanks
    xam
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: excel selection button

    It is not clear what you need. Now you are selecting one letter from one alphabet. What do you want to select from three different words? What result do you want?

    I am thinking this is not difficult once we understand what you want to do.

  3. #3
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    456

    Re: excel selection button

    Hi,
    as for the letters of the alphabet selection buttom2 they change
    do the same for the 3 words of the range H3:H5

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: excel selection button

    Guessing

    =INDEX(H3:H5,MOD(C3,3)+1)
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    456

    Re: excel selection button

    Hi bo_ry,
    thanks you work well
    A greeting
    xam
    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. [SOLVED] How to select a option button based on a command button selection and cell value
    By machoman4lyf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2018, 02:19 PM
  2. Option Button selection visible after selection another option button
    By brajpalshishodia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2015, 06:23 AM
  3. Auto Hide/Unhide rows in Excel based on radio button selection
    By awill110 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2013, 03:05 PM
  4. 'Save As' Macro button for a selection of an excel sheet- also as a pdf
    By shootingstarz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2012, 08:38 PM
  5. Excel Button to copy selection and then paste special values over it
    By transportplanner in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-14-2011, 07:00 AM
  6. [SOLVED] Excel should have unhide all worksheets selection or button.
    By JMayers97 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2006, 12:10 AM
  7. Excel should have a bar button to center across selection
    By Plantimacros in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-30-2005, 02:20 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