Floating Navigational Menu

[Marc Harmon]

I would like to make a floating menu or window containing buttons or icons
specific in action for one worksheet. The purpose will be to quickly and
easily move around on that worksheet.

The worksheet has 12 lists for each month. The size of each takes up the
entire viewable part of the window. Buttons on a floating menu or window,
assigned to each month's list, or to cells in the range I desire to view,
such as back to A1, would center the view I desire. I consider that a
custom toolbar will do this. But I would need to be able to put macros on
that toolbar.

I want to hit a button on the toolbar which will take me to that part of the
worksheet which has the list for:
June,
July,
etc.

Can you suggest web page references - How To examples of this type of
design, or give me some guidance or at least hints?
Thank You,
Marc

 

[Jim Gordon MVP]

Hi Mark,

Excel offers exactly what you have described. It's called a UserForm.

To make a UserForm visit the Visual Basic editor. View > Toolbars > Visual
Basic. Click the Visual Basic Editor Button

From the VB editor choose Insert > UserForm

When you make a userform the Tools menu turns on. It has controls you seek.
For example click the "Command Button" button and drag on the UserForm.
You'll get a button. Double-click the button and you'll see where to put the
code that gets activated when the button gets clicked.

You control properties for each userform object and for the userform itself
using the Properties pane. The pane is "context sensitive" meaning that it
displays the property of whatever object is currently selected.

When you are in the VB editor search the help file on the word UserForm. The
help is extensive and quite good. There are lots and lots of code examples
that you can copy and paste into your modules.

If you need to get started on visual basic here's an introductory tutorial:
Microsoft Excel for Macintosh
Visual Basic for Applications 101
<http://support.microsoft.com/default.aspx?scid=/support/macexcel/content/Ma
cVBA/MacVBA.asp>

The tutorial does not mention UserForms, however. So if you need any help
don't hesitate to post here or in microsoft.public.excel.programming. Be
sure to mention what version of Excel you are using so you don't get code
examples that involve Active-X or VB 6 (neither of these are supported in
the Mac Visual Basic model). But mostly explore the help system. It's really
good.

-Jim