+ Reply to Thread
Results 1 to 4 of 4

Using a scrollbar button to select and insert a text in cell from an input area.

  1. #1
    Forum Contributor
    Join Date
    01-13-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010 and 2016, but mostly 2010
    Posts
    123

    Using a scrollbar button to select and insert a text in cell from an input area.

    I know this is a very simple code and I had searched the net, but don't exactly know how to describe my search, to find the right solution.

    I had inserted a scrollbar button and want to use it to insert different text to a cell from an input area, just as using a combo box.
    I need several scroll buttons below each other, but they should all get the text from the same input area.

    I don't want to use a combo box, because I need to use a conditional formatting at the background and text in the output cell.
    The selected text should be able to copy to a different worksheet too - I believe I have the code to do that, but don't think I can do that, if i use a combo box.
    And I want to hide the scroll button in the print too, only to see the selected text at the print.

    Please look at the attached.
    Thank you in advance.

    Ib
    Attached Files Attached Files
    Last edited by gnaske; 01-12-2014 at 08:17 AM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,590

    Re: Using a scrollbar button to select and insert a text in cell from an input area.

    I have moved your scrollbars to column A and linked each one to its underlying cell. The formula in column B now refers to the cell in A to lookup the value in column G.

    I have set the print area to be column B only, so the scrollbars do not print.

    If you need to add more rows with scrollbars, see attributes LinkedCell in the scrollbar properties.

    If you need to change the location or size of the list of text, then you will have to update formulas in column B, and update Max in the scrollbars to match.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    01-13-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010 and 2016, but mostly 2010
    Posts
    123

    Re: Using a scrollbar button to select and insert a text in cell from an input area.

    Wouw. Very simple.
    You made it with simple Excel codes and I was trying to make it with VBA codes.

    Thank you

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,590

    Re: Using a scrollbar button to select and insert a text in cell from an input area.

    You are welcome and thank you for marking the thread "Solved"!

+ 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. Insert scrollbar at cell position
    By icyrius in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2013, 09:00 AM
  2. [SOLVED] input date column A, increment B, select blank cell in D and input time. in a macro
    By jeffstu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2012, 11:19 AM
  3. [SOLVED] Event Macro to insert text in cell based on input of another cell
    By nplouffe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-08-2012, 11:54 AM
  4. Insert Column on criteria of text input to cell
    By rickd909 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2007, 05:29 PM
  5. [SOLVED] insert scrollbar into a cell in Excel
    By Nick in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-19-2005, 01: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