I have a rather large spreadsheet and I want to program a command button that
would bring up the "go to" box that already has alphabetical references. I
realize the "Ctrl G" is the shortcut but I also would like the button and
place it in a freeze pane so it's always visible. I really don't know VBA.
I tried creating the command button and record a macro but it didn't work.
Any ideas would be greatly appreciated. I really wanted to make command
buttons for each letter of the alphabet and have it hyperlink to the
respected reference. I'm not sure how to do that either. What's the better
an easier way?
Thanks for your help.
Terry

here is the line of code to bring up the go to dialog

Application.Dialogs(xlDialogFormulaGoto).Show

I am not too sure what you want in terms of the alphabet buttons though...
--
HTH...

Jim Thomlinson


"TBoe" wrote:

I have a rather large spreadsheet and I want to program a command button that
would bring up the "go to" box that already has alphabetical references. I
realize the "Ctrl G" is the shortcut but I also would like the button and
place it in a freeze pane so it's always visible. I really don't know VBA.
I tried creating the command button and record a macro but it didn't work.
Any ideas would be greatly appreciated. I really wanted to make command
buttons for each letter of the alphabet and have it hyperlink to the
respected reference. I'm not sure how to do that either. What's the better
an easier way?
Thanks for your help.
Terry

Never mind. After selecting the references using Go To, I found using the
Namebox is excatly what they want. Thanks for looking.

"TBoe" wrote:

I have a rather large spreadsheet and I want to program a command button that
would bring up the "go to" box that already has alphabetical references. I
realize the "Ctrl G" is the shortcut but I also would like the button and
place it in a freeze pane so it's always visible. I really don't know VBA.
I tried creating the command button and record a macro but it didn't work.
Any ideas would be greatly appreciated. I really wanted to make command
buttons for each letter of the alphabet and have it hyperlink to the
respected reference. I'm not sure how to do that either. What's the better
an easier way?
Thanks for your help.
Terry