Programming a Command Button
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 |
Programming a Command Button
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 |
Programming a Command Button
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 |
All times are GMT +1. The time now is 11:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com