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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

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)
 
Upvote 0

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?
 
Upvote 0

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)
 
Upvote 0

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?
 
Upvote 0

Forum statistics

Threads
1,187,178
Messages
5,962,048
Members
438,578
Latest member
MrJimC

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