• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

Is there a way to create a scroll bar via vba to scroll through data within a range of cells that are merged together in excel?

I have an existing form that has the cells in range A3:H41 merged into one big cell.  It’s used to paste journal updates from helpdesk tickets and in many cases the string is longer than the 28 rows.  I want to create a scrollbar to make it easier view all of the text.  Please see the attached example.
Scrollbar-Example.xlsx
0
kbay808
Asked:
kbay808
2 Solutions
 
James ElliottManaging DirectorCommented:
I don't believe this is possible.
0
 
Rob HensonFinance AnalystCommented:
The only thing I can suggest is that you set the format of the cell to "Shrink to Fit". This will adjust the font size so that all contents can be seen in the cell area.

Thanks
Rob H
0
 
kbay808Author Commented:
Thanks for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now