+ Reply to Thread
Results 1 to 9 of 9

How to unscrunch this menu?

  1. #1
    Registered User
    Join Date
    01-15-2024
    Location
    Austin, Texas
    MS-Off Ver
    Mac Version 16.80
    Posts
    5

    Question How to unscrunch this menu?

    Hello, Mac user here.
    Version 16.80.
    I downloaded a bughet template and this menu option for selecting different date ranges is scrunched up and I can�t figure out how to increase the size so it�s all evenly spaced.


    Screenshot 2024-01-15 at 1.28.00 PM.png
    Attached Files Attached Files
    Last edited by FirstTim; 01-16-2024 at 12:21 AM.

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

    Re: How to unscrunch this menu?

    Welcome to the Forum FirstTim!

    Can you please attach the actual file?

    To attach a file, use the Paper Clip icon and follow instructions, or use this method:

    1. Under the text box where you type your reply click the Go Advanced button.
    2. On the next screen scroll down and under the Attachments section click the Manage Attachments link, which will show a pop-up window.
    3. Click the Choose File button to select a file to attached.
    4. Click the Upload button to upload the file.
    5. Then click the Close This Window button. Your file is now attached to your post.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    01-15-2024
    Location
    Austin, Texas
    MS-Off Ver
    Mac Version 16.80
    Posts
    5

    Re: How to unscrunch this menu?

    Just added the file! Thank you, I appreciate the instructions. Just found this site today!

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

    Re: How to unscrunch this menu?

    You are populating the listbox from an external file so I can't see exactly what you are seeing. So I tried populating it from another source and it looks OK to me. I'll see if I can find what may cause this on your end. I've never seen that before. The text size of a Forms listbox should be fixed. I've seen this kind of thing in cells when the cell height is to short, but that's not how the listbox works. It's possible this is something specific to a Mac, in which case I can't help.

  5. #5
    Registered User
    Join Date
    01-15-2024
    Location
    Austin, Texas
    MS-Off Ver
    Mac Version 16.80
    Posts
    5

    Re: How to unscrunch this menu?

    That is interesting. I downloaded the sheet of off this website (linked below) and it is one of the most popular personal finance tools online. There are several other tabs of data and inputs and being able to access that will probably help you with being able to find the source data.

    If not, is there a way to remove it totally and create your own? I wasn't able to but would appreciate help!

  6. #6
    Registered User
    Join Date
    01-15-2024
    Location
    Austin, Texas
    MS-Off Ver
    Mac Version 16.80
    Posts
    5

    Re: How to unscrunch this menu?

    SOLVED -
    Literally just had to double click in the right area of the listbox and drag it to the appropriate size I want it to be. totally fixed. I feel so foolish.

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

    Re: How to unscrunch this menu?

    In the file you provided, the listbox is populated from
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    It should be as in the template:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    However, you removed that sheet from the file you provided.

    I don't think any of that is what's causing your problem, though. Here is what the template looks like on my Windows box:

    template.jpg

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

    Re: How to unscrunch this menu?

    Quote Originally Posted by FirstTim View Post
    double click in the right area of the listbox and drag it to the appropriate size I want it to be
    That's odd. When I resize the listbox it does not affect the size of the text at all. Maybe this is something specific to the display on the Mac.

  9. #9
    Registered User
    Join Date
    01-15-2024
    Location
    Austin, Texas
    MS-Off Ver
    Mac Version 16.80
    Posts
    5

    Re: How to unscrunch this menu?

    That's so interesting. I think it probably has to do with the Mac/Windows issue. I am just glad it works now! And I appreciate the help you provided.

+ 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. Custom Right Click Menu and Sub-menu (disable inbuilt right click menu item)
    By analystbank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2020, 04:27 AM
  2. Pivot Table sort menu jumps to top of screen, tucking itself a bit under main Excel menu
    By GilaSki in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 01-11-2019, 04:15 AM
  3. Replies: 5
    Last Post: 02-17-2017, 04:50 PM
  4. [SOLVED] Losing a custom menu bar within Windows menu bar when new excel session is opened.
    By SCACCHIA in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-17-2014, 04:34 PM
  5. Replies: 3
    Last Post: 12-10-2009, 09:30 PM
  6. Replies: 0
    Last Post: 11-24-2005, 09:25 AM
  7. [SOLVED] Menu items added with menu item editor in older versions
    By Michael Hoffmann in forum Excel General
    Replies: 2
    Last Post: 01-07-2005, 10:06 AM

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