Results 1 to 6 of 6

Way to have floating ListBox on sheet?

Threaded View

  1. #1
    Registered User
    Join Date
    12-23-2010
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    66

    Way to have floating ListBox on sheet?

    Hello,

    So conceptually this is what I want. I have a sheet on excel with a bunch of data. Then, I want to have a dropdown menu, and depending on what is selected in the drop down menu, the data on the excel sheet changes. I want this drop down menu to be floating over the sheet so it's easy for the user to just switch data in the sheet. Think of it as a floating menu.
    • Now, I know I can create a list within a cell in excel but the issue with that is the sheet is huge. I don't want the user to constantly scroll back to find the cell with the list drop down. User could be looking at cell AA500, and if the menu is Cell A1, well, you have to always scroll back to A1, then scroll back to cell AA500, to return to what you were looking at.
    • I also know that you can create a listbox within form control, but the issue is, when you use that form control, you can't maneuver in the sheet anymore. And the form control is the only thing you can click on. So to change the data, you always have to run a macro, to open the list box. Which is repetitive and takes a lot of work for the user.

    What I would like is a floating box (like form control) so that it's always visible, you can move it around, but, you can still navigate within the sheet itself and click on cells. The last thing I can think of is to create a custom ribbon, but I don't have access to that at work - unless Excel 2017 gives you a way to edit it.

    Thanks!
    Last edited by anon; 03-20-2019 at 12:28 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Select a Sheet in Combobox. Show that's Sheet Data in Listbox.
    By svgopalareddy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-03-2018, 09:53 AM
  2. Floating pictures that don't scroll with sheet
    By jebersohl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2017, 01:37 PM
  3. [SOLVED] if anything in listbox select first item, if listbox empty do nothing (listbox in userform
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2015, 12:49 PM
  4. [SOLVED] Floating sheet or grid manipulation
    By alonglick in forum Excel General
    Replies: 5
    Last Post: 08-16-2014, 03:02 PM
  5. Listbox to Listbox, no duplicates & submitting same UserForm data for each Listbox entry.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2012, 12:18 PM
  6. [SOLVED] UserForm as a tool bar/ floating options for excel sheet
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2006, 11:55 AM
  7. Floating toolbar and floating comment?
    By StargateFan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2005, 06: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