How to set a tab stop for a command button
I have put a command button on a sheet, and there is code behind it, but I
don't know how to view that code. I have tried going to design mode and double clicking, but it just runs the procedure. If I'm in the VBA environment, where do I go to see the code and the properties for a command button? I have only a few cells unlocked, so the tab stops go to only those. Is there a way to make another tab stop on the command button? Thanks! -- Jeff Ciaccio Physics and AP Physics Teacher Sprayberry High School; Marietta, GA Blog: http://sprayberry.typepad.com/ciaccio |
How to set a tab stop for a command button
if it was created with the forms toolbar, just right click on it and choose
assign macro to see what the code is go to the vb editor to view the code in the module. if it was created with the control toolbox, then go to the vbe editor and doubl click the sheet name it resides on under excel objects. -- Gary "Jeff Ciaccio" wrote in message ... I have put a command button on a sheet, and there is code behind it, but I don't know how to view that code. I have tried going to design mode and double clicking, but it just runs the procedure. If I'm in the VBA environment, where do I go to see the code and the properties for a command button? I have only a few cells unlocked, so the tab stops go to only those. Is there a way to make another tab stop on the command button? Thanks! -- Jeff Ciaccio Physics and AP Physics Teacher Sprayberry High School; Marietta, GA Blog: http://sprayberry.typepad.com/ciaccio |
How to set a tab stop for a command button
Can I set a tab stop to bring the focus to the button?
"Gary Keramidas" <GKeramidasATmsn.com wrote in message ... if it was created with the forms toolbar, just right click on it and choose assign macro to see what the code is go to the vb editor to view the code in the module. if it was created with the control toolbox, then go to the vbe editor and doubl click the sheet name it resides on under excel objects. -- Gary "Jeff Ciaccio" wrote in message ... I have put a command button on a sheet, and there is code behind it, but I don't know how to view that code. I have tried going to design mode and double clicking, but it just runs the procedure. If I'm in the VBA environment, where do I go to see the code and the properties for a command button? I have only a few cells unlocked, so the tab stops go to only those. Is there a way to make another tab stop on the command button? Thanks! -- Jeff Ciaccio Physics and AP Physics Teacher Sprayberry High School; Marietta, GA Blog: http://sprayberry.typepad.com/ciaccio |
All times are GMT +1. The time now is 01:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com