shortcut key

y481184

Board Regular
Joined
Aug 1, 2003
Messages
137
I have another question. (Thanks for the help on the first one by the way) I wrote a lot of VB Code myself. I never actually "recorded" a macro. I placed a command button on the screen which dispays a form that I created. I would like to make the form appear with a shortcut key rather than relying on the command button. When I go to tools>macros, there are no macros in the list, so I don't know how to go about assigning a shortcut key. Any Suggetions?
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

santeria

Well-known Member
Joined
Oct 7, 2003
Messages
1,844
When you open the Macros list, select the Macros in this Workbook option down the bottom.
Once you have that, there should be an option to do a Short Cut in the Options section of the Dialogue Box.

(y)
 

y481184

Board Regular
Joined
Aug 1, 2003
Messages
137
Sorry, I tried that and still nothing displays. I know that there are macros because I wrote the code myself. Also, when i open the worksheet I get the message "The worksheet contains macros, do you still want to open it........?" So I am not sure here. any other suggestions?
 

santeria

Well-known Member
Joined
Oct 7, 2003
Messages
1,844
Okay... Can you get into the VBA editor, and see if you placed the Code into some sheet other than the Modules, or some other area?

The VBA Editor should show all accessable sheets in the workbook.


(y)
 

y481184

Board Regular
Joined
Aug 1, 2003
Messages
137
I'm sure thats where my problem lies. I inserted 2 forms into my project. To create the code, I just double-clicked on each form. So, my code is actually under the forms folder. There are no modules within my project. Do I need to change this?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,095
Messages
5,768,054
Members
425,451
Latest member
JohnBrooksBiddle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top