ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to assign a marco to a command button (https://www.excelbanter.com/excel-worksheet-functions/28376-how-assign-marco-command-button.html)

Eric

How to assign a marco to a command button
 
Can anyone advise me how can i assign a marco to the command button

I want to make a button when the use click on that will bring them to a
"range" - book store ( the bookmarked name)

Thanks in advance

Eric



Vasant Nanavati

If this is a CommandButton from the Control Toolbox, double-click on it
while in design mode and you will be taken to the "skeleton" macro, in which
you can write your code; e.g.:

Application.GoTo Range("Bookstore")

--

Vasant


"Eric" wrote in message
...
Can anyone advise me how can i assign a marco to the command button

I want to make a button when the use click on that will bring them to a
"range" - book store ( the bookmarked name)

Thanks in advance

Eric






All times are GMT +1. The time now is 04:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com